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 fAL8eWm96233 for ; Wed, 21 Nov 2001 03:40:33 -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 fAL8j6902860 for ; Wed, 21 Nov 2001 14:15:06 +0530 Date: Wed, 21 Nov 2001 14:07:28 +0530 From: Gurudutt X-Mailer: The Bat! (v1.52f) Reply-To: Gurudutt Organization: Indus Valley X-Priority: 3 (Normal) Message-ID: <13216589307.20011121140728@indvalley.com> To: pgsql-sql@postgresql.org Subject: Joins~ MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200111/300 X-Sequence-Number: 5682 This may be just a re-post of my previous mail, but unfortunately, I haven't got any reply whatsoever to this problem, Is the question too easy to answer or what, I couldn't get what it meant. I am posting the problem again, hopefully somebody will be able to give me a solution. ---------------------------------------------------------------------- I have two tables 1. tickettab 2. ticketmultab Both the tables have arrivaldate and arrivaltime as fields I want to sort the combination of the result set, like suppose an entry exists in tickettab as 2001-11-12 12:30 and the next entry in tickettab is 2001-11-12 16:40 if there exists a entry in ticketmultab as 2001-11-12 13.30 then I should get the results as follows ticketid arrival date arrival time 1 2001-11-12 12:30:00 -- tickettab entry 2 2001-11-12 13:30:00 --ticketmultab entry 3 2001-11-12 16:40:00 -- tickettab entry so depending on the arrival date and arrival time I need the result set to be sorted. I used bubble sort in php by moving the result set into an array and then sorting it. Is there any other way to do this thru SQL. -- Best regards, Gurudutt mailto:guru@indvalley.com Life is not fair - get used to it. Bill Gates