Hi Sergey,

One question about the solution you posted; I had not used an alias in a select comand before. Is there a benefit for using aliases (ie. ST1) in Select comands, or was this for clarification?

SELECT st1.date, st1.name, ;
st1.status_id, st1.stats_id, st1.lots_id ;
FROM status st1 ;
WHERE st1.stats_id = event1val ;
AND NOT EXISTS (SELECT * FROM status st2 ;
WHERE st1.lots_id = st2.lots_id ;
AND st2.stats_id = event2val)


Also (way off topic), how do you get your code to show with a different background color when posting to the thread?

Thanks again Sergey.

David