Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
5 Tables left out join problem
Message
 
 
À
12/01/2000 09:41:09
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00316921
Message ID:
00317027
Vues:
25
First try it with the joins un-nested. Note, you will no longer be able to use the View Designer to modify this view. You will have to maintain all the code for this in a PRG.[e.g., Create SQL View MyView as...]:
SELECT operation.CODE, operation.description, cRpt011.*, cRpt012.*,;
	cRpt013.*, cRpt014.*;
	FROM  operation ;
                    LEFT OUTER JOIN cRpt011;
                             ON  operation.CODE = cRpt011.operation1;
                    LEFT OUTER JOIN cRpt012;
	               ON  operation.CODE = cRpt012.operation2 ;
	      LEFT OUTER JOIN cRpt013;
	               ON  operation.CODE = cRpt013.operation3 ;
	      LEFT OUTER JOIN cRpt014 ;
	               ON  operation.CODE = cRpt014.operation4 ;
	ORDER BY 1;
	INTO CURSOR cLast
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform