Message-ID: <45002689.9050307@encs.concordia.ca>
Date: Thu, 07 Sep 2006 10:02:49 -0400
From: Emi Lu <emilu@encs.concordia.ca>
Reply-To: emilu@encs.concordia.ca
User-Agent: Thunderbird 1.5.0.5 (X11/20060719)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Re: Is it possible to left join based on previous joins result
References: <45001AF6.4020706@encs.concordia.ca>
In-Reply-To: <45001AF6.4020706@encs.concordia.ca>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I tried the example as the following:

create table a(col1);
create table b(col1, col2)

select a.*
from a inner join b using(col2)
left join b.col2 as c on (c.col1 = a.col1)

System notifies me that b is not a schema name.

So, I guess the approach that I tried to do is not acceptable by Pgsql 
grammar.


> 
> Is it possible to do something like:
> 
> select ...
> from t1
> inner join t2 ...
> left join t2.colN
> 
> When t1 inner join with t2 I got unique result for t2.colN( colN's value 
> is table name).
> 
> Can I continue to left join with the column "colN" in table t2?
> 
> Thanks
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
> 
>               http://archives.postgresql.org