FW: Why doesn't this query work?

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] &

RE: Why doesn't this query work?

DS', 'BLUE-GREENS', 'MID-PINKS', > 'NEUTRALS', 'PALE > BLUES & GREENS', 'MID-REDS', 'IVORY', 'GREENS', 'PALE PINKS & PEACHES', > 'WHITE') >AND pricelevel IN (1, 2, 3, 4, 5) >

Why doesn't this query work?

returned. Any ideas? Thanks for your help :-) Mikey SELECT * FROM msoft_codes as prod, application as app, application_list as list WHERE parentcolour IN ('BLACK', 'ORANGES', 'OLIVES-LINCOLN', 'GREYS', 'DARK REDS', 'GREEN-BROWNS', 'D

SELECT from multiple tables...

p and time... regards, Mikey - In theory, theory and practice should be the same, in practice it isn't.