Can I use cross join in VFP 6? I tried it but the word 'cross' didn't turn blue and I can't get the desired result. Any ideas? thanks very much! Please visit my WebCam!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
cross join in VFP 6
- Thread starter hmcheung
- Start date
rajeevnandanmishra
Programmer
Hi there,
I should not ask that why you want to use cross join. But still, i want to tell you that cross join is basically joining two (or more) tables without any criteria.
So if you issue
SELECT * FROM myTable1, myTable2 in VFP, it will give you the same result as
SELECT * FROM myTable1 CROSS JOIN myTable2 in OLD SQL.
Hope this will move you in right direction.
I should not ask that why you want to use cross join. But still, i want to tell you that cross join is basically joining two (or more) tables without any criteria.
So if you issue
SELECT * FROM myTable1, myTable2 in VFP, it will give you the same result as
SELECT * FROM myTable1 CROSS JOIN myTable2 in OLD SQL.
Hope this will move you in right direction.
- Status
Similar threads
