Received: from mail.enterprise.net (mail.enterprise.net [194.72.192.18])
	by hub.org (8.10.1/8.10.1) with ESMTP id e5PNDd160424
	for <pgsql-sql@postgresql.org>; Sun, 25 Jun 2000 19:13:39 -0400 (EDT)
Received: from linda.lfix.co.uk (cmax05-085.enterprise.net [212.161.115.85])
	by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id AAA03396
	for <pgsql-sql@postgresql.org>;
	Mon, 26 Jun 2000 00:13:38 +0100 (GMT/BST)
Received: from lfix.co.uk (olly@localhost [127.0.0.1])
	by linda.lfix.co.uk (8.11.0.Beta1/8.11.0.Beta1/Debian 8.11.0-1) with
	ESMTP id e5PN5we16803
	for <pgsql-sql@postgresql.org>; Mon, 26 Jun 2000 00:05:58 +0100
Message-Id: <200006252305.e5PN5we16803@linda.lfix.co.uk>
X-Authentication-Warning: linda.lfix.co.uk: Host olly@localhost [127.0.0.1]
	claimed to be lfix.co.uk
X-Mailer: exmh version 2.1.1 10/15/1999 (debian)
X-URL: http://www.lfix.co.uk/oliver
X-face: 
 "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F-
	KMLl*!h}B)u@TW|B}6<X<J|}QsVlTi:RA:O7Abc(@D2Y/"J\S,
	b1!<&<B/J}b.Ii9@B]H6V!+#sE0Q
	_+=`K$5TI|4I0-=Cp%pt~L#QYydO'iBXR~\tT?uftep9n9AF`@SzTwsw6uqJ}pL,
	h(cZi}T#PB"#!k
	p^e=Z.K~fuw$l?]lUV)?R]U}l; f*~Ol)#fpKR)Yt}XOr6BI\_Jjr0!@GMnpCTnTym4f; c{;
	Ms=0{`D Lq9MO6{wj%s-*N"G,g
To: pgsql-sql@postgresql.org
Subject: JOIN syntax
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Date: Mon, 26 Jun 2000 00:05:58 +0100
From: "Oliver Elphick" <olly@lfix.co.uk>
X-Archive-Number: 200006/224

Looking at SQL92, it seems that I ought to be able to do this:

SELECT * FROM invoice INNER JOIN (SELECT * FROM invoice_line WHERE lineno > 1) 
ON invoice.invno = invoice_line.invno;
ERROR:  parser: parse error at or near "("

(I know it can be successfully expressed in a more complex WHERE clause).

Is there anything wrong with the syntax, or is it a missing feature?

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "Honour thy father and mother; which is the first  
      commandment with promise; That it may be well with 
      thee, and thou mayest live long on the earth."        
                          Ephesians 6:2,3