[SQL] Is it possible to left join based on previous joins result

[Emi Lu]

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




---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org