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

Click here to load this message in the networking platform