On Mon, Dec 15, 2003 at 10:59:32AM -0000, Curley, Thomas wrote: > Guys > > Any idea why this query will not work in 4.0.13 > > select batch_id from BATCH > where NOT EXISTS (select 1 from TXN where TXN.batch_id = BATCH.batch_id) > > You have an error in your SQL syntax near 'EXISTS (select * from TXN where > TXN.batch_id = BATCH.batch_id)' at line 1
It's a subselect, and subselects aren't implemented in 4.0 - you need 4.1. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]