Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8792s793880 for ; Fri, 7 Sep 2001 05:02:54 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f878eWj04107 for pgsql-sql@postgresql.org; Fri, 7 Sep 2001 04:40:32 -0400 (EDT) (envelope-from news) From: "Maik" X-Newsgroups: comp.database.ms-access, comp.database.oracle, comp.databases.postgresql.sql, comp.databases.sybase, comp.databases Subject: Re: Combine query views into one SQL string Date: Fri, 7 Sep 2001 10:42:01 +0200 Organization: Chemnitz University of Technology Lines: 10 Message-ID: <9na15r$ku4$1@narses.hrz.tu-chemnitz.de> References: <63e57aa8.0109060835.33719290@posting.google.com> <3B97DC1F.94433F65@mbit.nl> X-Complaints-To: abuse@tu-chemnitz.de X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2462.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2462.0000 To: pgsql-sql@postgresql.org X-Archive-Number: 200109/77 X-Sequence-Number: 4723 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