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

Re: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: PostgreSQL Interfaces <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it
Date: 2001-04-30 14:05:34
Message-ID: 3AED712E.30409E16@flex.ro (view raw or flat)
Thread:
Lists: pgsql-interfaces
Constantin Teodorescu wrote:
> 
> Tried :
> select t0.name, t1.title, t2.nickname from authors t0 left outer JOIN
> books t1 ON (t0."id"=t1."author") , authors t0 left outer join nicknames
> t2 on (t0."id"=t2."id")


:-) After 30 seconds I have found the answer :


select t0.name, t1.title, t2.nickname from authors t0 left outer JOIN
books t1 ON (t0."id"=t1."author") left outer join nicknames
t2 on (t0."id"=t2."id")

Constantin Teodorescu
Braila, ROMANIA

pgsql-interfaces by date

Next:From: Tom LaneDate: 2001-04-30 14:24:24
Subject: Re: [INTERFACES] function returning NULL?
Previous:From: Constantin TeodorescuDate: 2001-04-30 13:55:02
Subject: MULTIPLE OUTER JOIN SYNTAX :-( can't quess it

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