X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 39D31474E42 for ; Tue, 8 Apr 2003 10:58:55 -0400 (EDT) Received: from smtp-out.net.ipl.pt (31.220.137.193.in-addr.arpa [193.137.220.31]) by postgresql.org (Postfix) with ESMTP id E8CFD4763B6 for ; Tue, 8 Apr 2003 10:58:52 -0400 (EDT) Received: (qmail 15518 invoked by uid 508); 8 Apr 2003 15:58:56 +0100 Received: from rutes@eselx.ipl.pt by smtp-int.net.ipl.pt by uid 505 with qmail-scanner (sophie: 2.10/3.64. Clear:. Processed in 0.04692 secs); 08 Apr 2003 14:58:56 -0000 X-IPLNet-RcptTo: pgsql-sql@postgresql.org Received: from matrix.eselx.ipl.pt (193.137.237.148) by 0 with SMTP; 8 Apr 2003 15:58:55 +0100 Received: from [172.21.3.60] (helo=eselx.ipl.pt) by matrix.eselx.ipl.pt with esmtp (Exim 3.35 #1 (Debian)) id 192uYi-0007Yt-00 for ; Tue, 08 Apr 2003 15:58:48 +0100 Message-ID: <3E92E3B1.7070405@eselx.ipl.pt> Date: Tue, 08 Apr 2003 15:58:57 +0100 From: rute solipa User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: help need it Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-11.7 required=5.0 tests=BAYES_10,TO_ADDRESS_EQ_REAL,USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/115 X-Sequence-Number: 12816 i've an oracle query: Select tb_users.ds_description, tb_users.cd_role, tb_users.cd_user, tb_users.ds_login, tb_monitores.cod_equipa from tb_users, tb_monitores where ds_login like 'varLogin' and ds_password like 'varPassword' and tb_users.cd_user = tb_monitores.cd_user(+) how can i transform it to an postgresql query? best regards etur