[Zope] ZSQL subselect P

Casey Duncan cduncan@kaivo.com
Tue, 13 Mar 2001 15:14:00 -0700


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
`------------------>