I am writing below SQL query in mapbasic to insert columns from two tables
t2 into table
Sites but error is occuring "Variable or field t2.CELLID not defined"
Table Sites (Source integer, N integer, LAT float, LONG float)
Select t1.CELLID, t2.CELLID, t2.LATITUDE, t2.LONGITUDE from t1 left join t2 on t1.CELLID=t2.CELLID where t1.obj within zone into Sites
Can anyone tell me how to rectify it?