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