Re: [Zope] ZSQL subselect P

Lee Marzke wrote:

Hi,

I'm trying to use a subquery with the following SQL syntax and get an error.

SELECT * from return WHERE requestid = ( SELECT requestid from return ORDER BY requestid LIMIT 1 )

Each part of the queary works seperatly but not together. Are their limitation on SQL statements that are allowed ?

Using Zope 2.3.0 and PostgresSQL 7.0.3 ZPoPyDA-1.2.tar.gz PoPy-2.0.2.tar.gz

I'm no MySQL expert, but generally you would use the IN operator when doing subselects. Can MySQL even do subselects?? -- | Casey Duncan | Kaivo, Inc. | cduncan@kaivo.com `------------------>