Many thanks Chris
-Original Message-
From: Chris Elsworth [mailto:[EMAIL PROTECTED]
Sent: 15 December 2003 11:22
To: Curley, Thomas
Cc: [EMAIL PROTECTED]
Subject: Re: NOT EXISTS
On Mon, Dec 15, 2003 at 10:59:32AM -, Curley, Thomas wrote:
> Guys
>
> Any idea why this query
"Curley, Thomas" <[EMAIL PROTECTED]> wrote:
>
> 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 =3D BATCH.batch_id=
> )
>
> You have an error in your SQL syntax near 'EXISTS (select * from TXN wher=
> e TXN.b
On Mon, Dec 15, 2003 at 10:59:32AM -, 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 * fro
