| From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
|---|---|
| To: | Tina Messmann <tina(dot)messmann(at)xinux(dot)de> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: full join...using and version of pgsql |
| Date: | 2004-04-14 20:39:52 |
| Message-ID: | Pine.LNX.4.33.0404141439410.32036-100000@css120.ihs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenneth Gonsalves | 2004-04-15 01:38:54 | SET idiom in insert statement |
| Previous Message | Tina Messmann | 2004-04-14 17:05:57 | full join...using and version of pgsql |