Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Query Question
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00961929
Message ID:
00961937
Views:
9
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform