Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Full Outer Join
Message
From
12/09/2001 11:42:32
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Full Outer Join
Miscellaneous
Thread ID:
00555540
Message ID:
00555540
Views:
44
Hi,

I rarely, if ever have done full outer joins before. (basically all data in table a joined with all data in table b) I am not sure of the syntax,
select curRules.question, curRules.ansdescrip, curRules2.question2, ;
        curRules2.ansdescrip ;
	FROM curRules FULL OUTER JOIN curRules2 ;
	INTO CURSOR curRules3
The thing that confuses me is what I put in the 'ON' part. There are no fields that have to be equal.

Thanks,
Chris
Next
Reply
Map
View

Click here to load this message in the networking platform