Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I do multiple JOINS in an SQL SELECT?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
How do I do multiple JOINS in an SQL SELECT?
Divers
Thread ID:
00361751
Message ID:
00361751
Vues:
46
Is this how?

SELECT *;
FROM mytable ;
LEFT JOIN yourtable ON mytable.mydata1 = yourtable.yourdata1 ;
LEFT JOIN yourtable ON mytable.mydata2 = yourtable.yourdata2 ;
LEFT JOIN yourtable ON mytable.mydata3 = yourtable.yourdata3 ;
INTO CURSOR rpt

Thanks for the info.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site: www.stephenkramer.com
Would you believe Far Side Lite?
More than 270 original cartoons.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform