Skip site navigation (1) Skip section navigation (2)

Re: Outer join question?

From: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Outer join question?
Date: 2009-04-08 16:55:32
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
You're right.  This did it.


On Apr 8, 2009, at 9:12 AM, Aurimas Černius wrote:

> Hi,
>> I have three tables that create a many-to-many relationship between  
>> two
>> of them. One of them has person data and one of them has contact  
>> data,
>> and, of course, the other is the bridge table. I want to select all  
>> the
>> people in the people table with the last name like Smith and join it
>> with their contact information. Sometimes they have no contact
>> information, but I want to put them on my list anyway. I typically  
>> use
>> the old syntax of the "where clause" to join tables, so I have two
>> questions. Is there a syntax in postgres to do an outer join using  
>> the
>> "where clause" and what would be the correct syntax to join the three
>> tables using the newer standard,
>> SELECT last_name, first_name, contact
>> FROM people
>> LEFT (or RIGHT) JOIN bridge ON bridge.peopleid = people.peopleid
>> JOIN contact ON bridge.contactid = contact.contactid
>> WHERE last_name like 'Smi%';?
>> The above query is incorrect and I can't seem to get the result I'm
>> looking for.
> I think both joins should be LEFT.
> -- 
> Aurimas
> -- 
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:

In response to

pgsql-novice by date

Next:From: Just E. MailDate: 2009-04-08 22:28:39
Subject: Where is PostgreSQL root directory?
Previous:From: MaxDate: 2009-04-08 16:14:50
Subject: Re: scripts for the tutorial

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group