Received: from 10.0.0.4 (mail.adestagroup.com [208.245.233.8]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAU0Ppt79430 for ; Wed, 29 Nov 2000 19:25:51 -0500 (EST) (envelope-from kthompson@adestagroup.com) Received: from MFSNTOMAM_DOMAIN-Message_Server by 10.0.0.4 with Novell_GroupWise; Wed, 29 Nov 2000 18:24:55 -0600 Message-Id: X-Mailer: Novell GroupWise 5.5.2 Date: Wed, 29 Nov 2000 18:24:39 -0600 From: "Kenn Thompson" To: Subject: Subselect in join? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by mail.postgresql.org id eAU0Pqt79431 X-Archive-Number: 200011/280 X-Sequence-Number: 311 Ok- Seems I've seen this somewhere, but can't seem to get it to work. Is my memory flawed, or is this just not an implemented feature? SELECT * FROM (SELECT foo, bar FROM tfoobar) In english- is it not possible to to a subselect in a FROM clause? Kenn ____________________________________________ Kenn Thompson Senior Web Architect Adesta Communications Work: 402.233.7595 Cell: 402.210.6326