Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Statement using 5 tables
Message
De
14/04/2004 10:24:45
 
 
À
14/04/2004 10:08:43
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00894654
Message ID:
00894766
Vues:
6
How do I do multiple full outer joins to the 4 tables? I got it for one table.

SELECT H.CUSIP, H.ACCOUNT, NVL(sourcedoc.doc_recv,'Not Defined') AS source_doc;
FROM holdrecn H FULL OUTER JOIN sourcedoc;
on h.source_num=sourcedoc.source_num;
where &itemtype

but I need it for 3 more tables

NVL(PD.reas_desc,'Not Defined') AS Ovr30_reas,;
NVL(R.OOB_desc,'Not Defined') AS oob_reason,;
NVL(A.OOB_desc,'Not Defined') AS act_taken
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform