Ahh, thanks

I'm not worthy!!!!
(bows down in worship)



>>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