Ahem, please ignore this post - I should have been doing: AND app.id IN (7, 23, etc.)
DOH! Thanks to everyone for their help though... Mikey > -----Original Message----- > From: Mikey [mailto:[EMAIL PROTECTED] > Sent: 31 May 2003 12:53 > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: RE: Why doesn't this query work? > > > > 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, > > 22, > > 3, 17, 4, 8, 21, 2, 27, 15, 1, 26, 12) > > group by list.prodcode > > order by list.prodcode > > I have run this query and it returns absolutely nothing > > > select count(*) , list.prodcode > > from msoft_codes as prod, application_list as list > > WHERE prod.parentcolour IN ('BLACK', 'ORANGES', > > 'OLIVES-LINCOLN', 'GREYS', > > 'DARK REDS','GREEN-BROWNS', 'DARK BLUES', 'LAVENDERS/LILACS', 'BROWNS', > > 'BLUES','MAUVES', 'CORN/GOLDS', 'BLUE-GREENS', 'MID-PINKS', > > 'NEUTRALS', 'PALE > > BLUES & GREENS', 'MID-REDS', 'IVORY', 'GREENS', 'PALE PINKS & PEACHES', > > 'WHITE') > > AND pricelevel IN (1, 2, 3, 4, 5) > > AND prod.prodcode=list.prodcode > > group by list.prodcode > > order by list.prodcode > > However, this query returns 1677 results... any ideas? I really > need to get this query working ASAP so any help is greatly appreciated :) > > Mikey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]