Received: from gateway.indvalley.com (ptil-134-144-ban.primus-india.net [203.196.144.134] (may be forged)) by postgresql.org (8.11.3/8.11.4) with ESMTP id fAN8KJm12046 for ; Fri, 23 Nov 2001 03:20:19 -0500 (EST) (envelope-from guru@indvalley.com) Received: from GURU ([192.168.0.20]) by gateway.indvalley.com (8.11.2/8.11.2) with ESMTP id fAN8Jx204501; Fri, 23 Nov 2001 13:49:59 +0530 Date: Fri, 23 Nov 2001 13:41:43 +0530 From: Gurudutt X-Mailer: The Bat! (v1.52f) Reply-To: Gurudutt Organization: Indus Valley X-Priority: 3 (Normal) Message-ID: <1575268728.20011123134143@indvalley.com> To: Markus Bertheau CC: postgres sql list Subject: Re: Joins~ - Thanks a lot~ In-Reply-To: <1006502123.4636.0.camel@entwicklung01.cenes.de> References: <13216589307.20011121140728@indvalley.com> <1006343880.29221.13.camel@entwicklung01.cenes.de> <10524699358.20011122161018@indvalley.com> <1006502123.4636.0.camel@entwicklung01.cenes.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/336 X-Sequence-Number: 5718 Hello Markus, It worked like anything, Thanks a lot, actually it saved so much of my code in php, infact a function had been writted to do the same. Thanks again -- Best regards, Gurudutt mailto:guru@indvalley.com Life is not fair - get used to it. Bill Gates Friday, November 23, 2001, 1:25:22 PM, you wrote: >> 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 MB> Oh, I see, joining is of course false, my fault. must be like this, i MB> think: MB> select from tablea union select from tableb MB> order by MB> I tried it with two sample tables on 7.1.3 and it worked: bert=>> select version(); MB> version MB> ------------------------------------------------------------- MB> PostgreSQL 7.1.3 on i686-pc-linux-gnu, compiled by GCC 2.96 MB> (1 row) bert=>> \d ta MB> Table "ta" MB> Attribute | Type | Modifier MB> -----------+---------+----------------------------------------------- MB> id | integer | not null default nextval('"ta_id_seq"'::text) MB> data | text | MB> i | integer | MB> Index: ta_id_key bert=>> \d tb MB> Table "tb" MB> Attribute | Type | Modifier MB> -----------+---------+------------------------------------ MB> id | integer | default nextval('ta_id_seq'::text) MB> data | text | MB> i | integer | bert=>> select * from ta; MB> id | data | i MB> ----+------+--- MB> 1 | qwe | 1 MB> 2 | ert | 3 MB> 3 | tzu | 5 MB> (3 rows) bert=>> select * from tb; MB> id | data | i MB> ----+------+--- MB> 4 | wer | 2 MB> 5 | rtz | 4 MB> 6 | zui | 6 MB> (3 rows) bert=>> select * from ta union select * from tb order by i; MB> id | data | i MB> ----+------+--- MB> 1 | qwe | 1 MB> 4 | wer | 2 MB> 2 | ert | 3 MB> 5 | rtz | 4 MB> 3 | tzu | 5 MB> 6 | zui | 6 MB> (6 rows) MB> Markus Bertheau