Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Full Outer Join
Message
 
 
To
12/09/2001 11:42:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00555540
Message ID:
00555548
Views:
14
>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

If this is the case and you want the resulting table to be multiplication of the two, you can use
select curRules.question, curRules.ansdescrip, curRules2.question2, ;
        curRules2.ansdescrip ;
	FROM curRules, curRules2 ;
	INTO CURSOR curRules3
Note, that the result would be huge (depends on number of records in both files, of course) and you should have enough memory and free space in temp folder.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform