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

Re: Outer join question?

From: Aurimas Černius <aurisc4(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Outer join question?
Date: 2009-04-08 13:12:29
Message-ID: 49DCA2BD.6060007@gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: MaxDate: 2009-04-08 14:53:04
Subject: scripts for the tutorial
Previous:From: Carol WalterDate: 2009-04-08 13:02:54
Subject: Outer join question?

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