> -Original Message-
> From: Mikey [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 30, 2003 11:53 AM
> To: [EMAIL PROTECTED]
> Subject: Why doesn't this query work?
>
>
> OK, first of all thanks for the pointers, however, the query I now have
> doesn't seem to work. If I run the query up unt
> You might try some partial queries before the big one to see if there are
> reasonable results -
>
> select count(*) , list.prodcode
> from application as app, application_list as list
> where app.id=list.appl_id
>AND app.name IN (7, 23, 16, 9, 18, 24, 25, 5, 13, 11, 10, 6,
> 20, 14, 19,