Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3DMk9840045 for ; Fri, 13 Apr 2001 18:46:09 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from prodserver1.goatelecom.com ([210.212.161.28]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3DIBf889511 for ; Fri, 13 Apr 2001 14:11:42 -0400 (EDT) (envelope-from sharmad@goatelecom.com) Received: from sanico.sharmad.org by prodserver1.goatelecom.com (8.9.3/1.1.20.3/07Jul00-0916AM) id XAA0000010343; Fri, 13 Apr 2001 23:46:45 +0530 (IST) Received: (from sharmad@localhost) by sanico.sharmad.org (8.9.3/8.9.3) id XAA00863 for pgsql-sql@postgresql.org; Fri, 13 Apr 2001 23:32:41 +0530 X-Authentication-Warning: sanico.sharmad.org: sharmad set sender to sharmad@goatelecom.com using -f Date: Fri, 13 Apr 2001 23:32:41 +0530 From: Sharmad Naik To: pgsql-sql@postgresql.org Subject: SELECT query Message-ID: <20010413233241.A844@goatelecom.com> Reply-To: Sharmad Naik Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.5i X-Archive-Number: 200104/216 X-Sequence-Number: 2566 I have three table called table1, table2, table3 all having fields like: table1 contain id and username and id referencing table4 table2 contains id and parallel_username and id referencing table4 table3 contains id and other_username and id referencing table4 table4 is the main table containing id as primary key I want to develop a search engine which shows unique record after searching all the three table but shouldn't contain multiple answers for same SEARCH for username Pls help me, -Regards, Sharmad -- The secret of the universe is @*&í!'ñ^#+ NO CARRIER __ _ _ _ _ |_|_||_||_||\/||_|| \ _|| || || \| || ||_/