Thread: Joining several tables
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 -- Stephan Richter CBU - Physics and Chemistry Student Web2k - Web Design/Development & Technical Project Management
1) Select t1.* from table_1 t1, table2 t2 where t1.column = t2.column; 2) Select t1.* from table_1 t1 join table2 t2 on t1.column = t2.column; -----Original Message----- From: Stephan Richter [SMTP:srichter@cbu.edu] Sent: Sunday, January 21, 2001 11:20 PM To: pgsql-sql@postgresql.org Subject: Joining several tables 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 -- Stephan Richter CBU - Physics and Chemistry Student Web2k - Web Design/Development & Technical Project Management
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'll work ok. SELECT street,phone,contname FROM Address a, PhoneNumber p, Contact c WHERE a.contactid=p.contactid and a.contactid=c.contactid; I have no affiliation with cold remedy manufacturers (heh, Contact c...) "Stephan Richter" <srichter@cbu.edu> wrote in message news:4.3.1.0.20010122001803.00a99dd0@198.78.130.6... > 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 > -- > Stephan Richter > CBU - Physics and Chemistry Student > Web2k - Web Design/Development & Technical Project Management >