Re: [SQL] Joining several tables

2001-01-24 Thread PM
As long as the contactid is not null in any of the tables its easy. You didn't give any column name information so I'll wing it. Not knowing the relationships between the tables means this might get you a fair amount of repeat data. If there is only ONE row in each table for a given contactid it'l

[SQL] Joining several tables

2001-01-21 Thread Stephan Richter
Hello, I have the following situation: I have an Address, PhoneNumber and Contact table all having a contactid in common, but sometimes the phone number does not exist. I want to join these three tables. How do I do that? I could not find the syntax for multiple tables... Regards, Stephan --