Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8982w779719 for ; Sun, 9 Sep 2001 04:03:01 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f897kwr38947 for pgsql-sql@postgresql.org; Sun, 9 Sep 2001 03:46:58 -0400 (EDT) (envelope-from news) From: "Tony Hunt" X-Newsgroups: comp.database.ms-access, comp.database.oracle, comp.databases.postgresql.sql, comp.databases.sybase, comp.databases References: <63e57aa8.0109060835.33719290@posting.google.com> <3B97DC1F.94433F65@mbit.nl> <9na15r$ku4$1@narses.hrz.tu-chemnitz.de> <3B988C82.9C4782E4@mbit.nl> Subject: Re: Combine query views into one SQL string Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Sun, 09 Sep 2001 07:46:56 GMT X-Complaints-To: news@bigpond.net.au Organization: BigPond Internet Services (http://www.bigpond.net.au) To: pgsql-sql@postgresql.org X-Archive-Number: 200109/83 X-Sequence-Number: 4737 I don't get it? What's the difference between an inner-join and an equijoin? "Nils Zonneveld" wrote in message news:3B988C82.9C4782E4@mbit.nl... > > > Maik wrote: > > > > 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; > > > > Yeps, thats another way to write an inner join :-) > > Mazzel, > > Nils > > -- > Alles van waarde is weerloos > Lucebert