date time color 20001001 18:03:12 RED 20001001 18:03:13 PINK 20001001 18:03:14 ORANGE 20001001 18:03:15 TEAL 20001001 18:03:16 GREEN 20001001 18:03:17 YELLOW 20001001 18:03:18 BLACK 20001001 18:03:19 WHITEI need to select from the green down. I've been doing it like this:
select *, date+time as logkey from audit_trail into cursor stuff select * from stuff where log_key >= (select log_key from stuff where color = "GREEN")The problem is that there may be more than one green record, but I need to select all the changes since the first green record. I thought about using TOP, but that doesn't work in a sql select.