Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Query Question
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00961929
Message ID:
00961937
Vues:
10
>Is it possible to join more than 2 tables:
>
>I have customers, with a one-to-many's into 3 tables, addresses, phones and emails.
>
>I need one record for each client, addresses, phone and email combo.
>
>Addresses, phones and emails are linked to the client record via a pivit table
>called Links.
>
>Thanks

Of course.

... FROM CUSTOMERS
(LEFT) Join Addresses on Customer.PK = Addresses.Cust_FK
(LEFT) Join Phone on Customer.PK = Phone.Cust_FK
(LEFT) Join EMail on Customer.PK = EMail.Cust_FK
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform