MI-L Using variables in SQL Select

[Sam Shelley]

Hi Listers,

 

Does anyone know how to use variables pointing to table name and column
names in a MapBasic SQL query.  Following is and example of the section
code that I am using but the compiler doesn't like it:

 

Table1= TableInfo(1, TAB_INFO_NAME)

Table2= TableInfo(2, TAB_INFO_NAME)

 

 

Col1 = ColumnInfo(Table1, "col1", COL_INFO_NAME)

 

Col2 = ColumnInfo(Table2, "col1", COL_INFO_NAME)

 

Select *

 

>From  Table1, Table2

Where 

 

Table1.Col1 = Table2.Col2

 

Any help would be much appreciated, as I have run into this problem
before but have been able to get around it but this time I can't.

 

Thanks Sam