Received: from gl.aser.de (gl.aser.de [213.252.128.30]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2T9K5U37038 for ; Thu, 29 Mar 2001 04:20:10 -0500 (EST) (envelope-from gcg@gl.aser.de) Received: from pinguin (gcg@node122.dial.Uni-Magdeburg.DE [141.44.160.122]) by gl.aser.de (8.11.2/8.11.2/Debian 8.11.2-1) with SMTP id f2T9QEa31806; Thu, 29 Mar 2001 11:26:14 +0200 Content-Type: text/plain; charset="iso-8859-1" From: Christof Glaser Organization: gl.aser software engineering . internet service To: David Olbersen , Subject: Re: Self-Referencing Date: Thu, 29 Mar 2001 11:27:37 +0200 X-Mailer: KMail [version 1.2] References: In-Reply-To: MIME-Version: 1.0 Message-Id: <01032911273700.00783@pinguin> Content-Transfer-Encoding: 8bit X-Archive-Number: 200103/599 X-Sequence-Number: 2269 On Thursday, 29. March 2001 01:38, David Olbersen wrote: [snip] > SELECT > building_id, > num_buildings, > ( > SELECT count( building_id ) > FROM building_portals > WHERE building_id = THIS.building_id > ) > FROM buildings; Try this query (untested), using table aliases: SELECT b.building_id, b.num_buildings, ( SELECT count( bp.building_id ) FROM building_portals bp WHERE bp.building_id = b.building_id ) FROM buildings b; You could also write . instead. Hope that helps. Christof -- gl.aser . software engineering . internet service http://gl.aser.de/ . Planckstraße 7 . D-39104 Magdeburg Tel. +49.391.7 44 77 10 . Fax +49.391.7 44 77 13 . Mobil 0177.77 92 84 3