Received: from p1.selectacast.net (IDENT:root@p1.selectacast.net [206.41.1.251]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA47504 for ; Tue, 23 May 2000 18:53:50 -0400 (EDT) (envelope-from jks@selectacast.net) Received: from selectacast.net (IDENT:jks@d1 [209.219.91.66]) by p1.selectacast.net (8.9.3/8.9.3) with ESMTP id SAA21791 for ; Tue, 23 May 2000 18:53:49 -0400 Message-ID: <392B0BFC.BB2CD23B@selectacast.net> Date: Tue, 23 May 2000 18:53:48 -0400 From: Joseph Shraibman Organization: Xtenit X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.15 i686) X-Accept-Language: en MIME-Version: 1.0 To: "pgsql-sql@postgresql.org" Subject: two fields in subselect Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/110 I want to do this: SELECT a, (select x,y,z from table2 where table1.a = table2.w), b, c from table1; But postgres complains: ERROR: Subselect must have only one field How can I get around this?