You're right. This did it.
On Apr 8, 2009, at 9:12 AM, Aurimas Černius wrote:
>> I have three tables that create a many-to-many relationship between
>> of them. One of them has person data and one of them has contact
>> and, of course, the other is the bridge table. I want to select all
>> 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
>> 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
>> "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.
> 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. Mail||Date: 2009-04-08 22:28:39|
|Subject: Where is PostgreSQL root directory?|
|Previous:||From: Max||Date: 2009-04-08 16:14:50|
|Subject: Re: scripts for the tutorial|