Re: mysql subquery too slow

[Felix Geerinckx]

S C wrote:

> I'm trying to report all trades that have skipped the MODIFIED state, they just jump from NEW to
> PROCESSED

Not sure if I understand your requirements completely. Does this do what you want?

SELECT s1.*
FROM stack s1
LEFT JOIN stack s2 ON s2.trade_num = s1.trade_num AND s2.status = 'MODIFIED'
WHERE
s1.date_appeared = CURRENT_DATE AND
s1.status = 'PROCESSED' AND
s2.status IS NULL;

--
felix
Please use BBCode to format your messages in this forum.