Re: full join...using and version of pgsql - Mailing list pgsql-sql

On Wed, 14 Apr 2004, Tina Messmann wrote:

> hello list,
> 
> i am using pgsql 7.2.1
> i need something like
> 
> select * from t1 full join t2 using(bla) full join t3 using(bla)
> 
> i searched the archives and found that this is not possible with my 
> version of postgres.
> is this implemented in newer versions of postgres? since which version?
> 
> i'll try the alternative select * from t1 full join t2 on(t1.bla=t2.bla) 
> full join t3 on(t1/t2.bla=t3.bla)
> but this is not the best solution for me i think....

I think you are looking for a natural join.