Hello List members !!
I am facing one problem with SQL, I want to join two tables, and they have a join
condition as well. the problem is table name (oone of them) is variable,
like the table name is like that sales9902 (sales of feb 99, here 9902 will keep on
changing and
the table with which I want to join has say WD field common, so the problem is
if I am using given syntex it works
Select * from sales9902, depots where sales9902.wd = depots.WD into xxx
(where I have variable nyymm = 9902 so table name is like "sales"+nyymm
if I assign "sales"+nyymm+".wd"
or make another variable sztable1 = "sales"+nyymm+".wd"
Select * from sales9902 , depots where sztable1 =depots.WD into yyy
then it says there is no join clause specified
Please help me to solve the problem
regards
===================================================
Aditya
Executive (Systems)
Information Systems Department
GCMMF, Anand
[E-mail me at [EMAIL PROTECTED]]
===================================================
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
