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 until "pricelevel IN (1, 2, 3,
4, 5)" it returns a large result set (the clauses are fairly inclusive),
however, when I add in the rest of the query no results are 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', '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
AND 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)
regards,
Mikey
- In theory, theory and practice should be the same, in practice it isn't.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
