Re: Combine query views into one SQL string

From: "Maik" <K(dot)Maik(at)web(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Combine query views into one SQL string
Date: 2001-09-07 08:42:01
Message-ID: 9na15r$ku4$1@narses.hrz.tu-chemnitz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Its clear, union concat the two results.

But he can also use this join version, if its the intention.

select t1.id, sum(t1.amount), t2.id, sum(t2.amount) from table1 as t1,
table2 as t2 where t1.id=t2.id;

Ciao Maik

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Nils Zonneveld 2001-09-07 09:00:01 Re: Combine query views into one SQL string
Previous Message Nils Zonneveld 2001-09-07 08:10:32 Re: Combine query views into one SQL string