Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Full Outer Join
Message
 
 
À
12/09/2001 11:42:32
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00555540
Message ID:
00555548
Vues:
15
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform