Is it possible to left join based on previous joins result

From: Emi Lu <emilu(at)encs(dot)concordia(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Is it possible to left join based on previous joins result
Date: 2006-09-07 13:13:26
Message-ID: 45001AF6.4020706@encs.concordia.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Aaron Bono 2006-09-07 14:01:41 Re: Query regarding to MS reporting services (Grand total problem)
Previous Message Mario Splivalo 2006-09-07 10:32:15 Re: Postgres regexp matching failure?