Is it possible to left join based on previous joins result - Mailing list pgsql-sql

From Emi Lu
Subject Is it possible to left join based on previous joins result
Date
Msg-id 45001AF6.4020706@encs.concordia.ca
Whole thread Raw
Responses Re: Is it possible to left join based on previous joins result
Re: Is it possible to left join based on previous joins result
List pgsql-sql
Hello,

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





pgsql-sql by date:

Previous
From: Mario Splivalo
Date:
Subject: Re: Postgres regexp matching failure?
Next
From: "Aaron Bono"
Date:
Subject: Re: Query regarding to MS reporting services (Grand total problem)