Received: from hub.org.org (localhost [127.0.0.1]) by hub.org (8.10.1/8.10.1) with SMTP id e99Nk1J51909 for ; Mon, 9 Oct 2000 19:46:01 -0400 (EDT) Received: from nt2.softlink.ch (hidden-user@gw.softlink.ch [212.243.26.27]) by hub.org (8.10.1/8.10.1) with ESMTP id e9390wr76753 for ; Tue, 3 Oct 2000 05:00:59 -0400 (EDT) Received: by mail.softlink.ch with Internet Mail Service (5.5.2650.21) id ; Tue, 3 Oct 2000 10:16:11 +0200 Message-ID: From: "Nema, Vivek" To: "'pgsql-sql@postgresql.org'" Subject: -query sql Date: Tue, 3 Oct 2000 10:16:02 +0200 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2650.21) Content-Type: text/plain; charset="iso-8859-1" X-Archive-Number: 200010/95 X-Sequence-Number: 1757 Hi! a small query may be u can help me. i just wanted to compare 2 columns in 2 tables.how can i do it in sql statement.i know it is possible somehow i am not able to write my query. i am using RDB 6.0 Any pointer or help will be highly appreciated. Thanx -vivek