Received: from leela.one-2-one.net (leela.one-2-one.net [217.115.142.65]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAN7tTm06691 for ; Fri, 23 Nov 2001 02:55:30 -0500 (EST) (envelope-from twanger@bluetwanger.de) Received: from [192.168.0.14] (p3E9EC1AC.dip.t-dialin.net [62.158.193.172]) by leela.one-2-one.net (8.11.0/8.11.0) with ESMTP id fAN7uHZ18653; Fri, 23 Nov 2001 08:56:18 +0100 Subject: Re: Joins~ From: Markus Bertheau To: Gurudutt Cc: postgres sql list In-Reply-To: <10524699358.20011122161018@indvalley.com> References: <13216589307.20011121140728@indvalley.com> <1006343880.29221.13.camel@entwicklung01.cenes.de> <10524699358.20011122161018@indvalley.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/0.99.2 (Preview Release) Date: 23 Nov 2001 08:55:22 +0100 Message-Id: <1006502123.4636.0.camel@entwicklung01.cenes.de> Mime-Version: 1.0 X-Archive-Number: 200111/334 X-Sequence-Number: 5716 > select tickettab.tokenid, ticketmultab.techcode,ticketmultab.techcode, > tickettab.problemstmt,ticketmultab.problemstmt > from (tickettab LEFT JOIN ticketmultab ON tickettab.tokenid=ticketmultab.tokenid) > as ticketjoinedtab order by > ticketjoinedtab.arrivaldate desc, > ticketjoinedtab.arrivaltime desc Oh, I see, joining is of course false, my fault. must be like this, i think: select from tablea union select from tableb order by I tried it with two sample tables on 7.1.3 and it worked: bert=> select version(); version ------------------------------------------------------------- PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96 (1 row) bert=> \d ta Table "ta" Attribute | Type | Modifier -----------+---------+----------------------------------------------- id | integer | not null default nextval('"ta_id_seq"'::text) data | text | i | integer | Index: ta_id_key bert=> \d tb Table "tb" Attribute | Type | Modifier -----------+---------+------------------------------------ id | integer | default nextval('ta_id_seq'::text) data | text | i | integer | bert=> select * from ta; id | data | i ----+------+--- 1 | qwe | 1 2 | ert | 3 3 | tzu | 5 (3 rows) bert=> select * from tb; id | data | i ----+------+--- 4 | wer | 2 5 | rtz | 4 6 | zui | 6 (3 rows) bert=> select * from ta union select * from tb order by i; id | data | i ----+------+--- 1 | qwe | 1 4 | wer | 2 2 | ert | 3 5 | rtz | 4 3 | tzu | 5 6 | zui | 6 (6 rows) Markus Bertheau