Received: from sol.eori.net.pl (IDENT:root@sol.eori.net.pl [212.244.119.2]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA51347 for ; Mon, 10 Apr 2000 13:36:15 -0400 (EDT) (envelope-from robertn@eori.net.pl) Received: from adave (adave.eori.net.pl [212.244.119.9] (may be forged)) by sol.eori.net.pl (8.9.3/8.9.3) with SMTP id TAA10844 for ; Mon, 10 Apr 2000 19:36:08 +0200 From: "Robert Nosko" To: Subject: How to do this in PostgreSQL? Date: Mon, 10 Apr 2000 19:38:19 -0700 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-reply-to: <15536.955375396@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Importance: Normal X-Archive-Number: 200004/92 Hi, In ORACLE I can perform the following query: SELECT tableA.id, title, qty FROM tableA, (SELECT id, count(*) qty FROM tableB group by id) tableC WHERE tableA.id = tableC.id (+) but in PostgreSQL I get error message. How can I perform it in Postgres? thanks, robert