Hi,

I have two cursors. Both have the same 3 fields. RO_num, item_date, item_descr. Each cursor already contains the top dates for each ro_num for that cursor.
Now I need to retrieve the top date for each RO_num in both cursors. Sometimes cursor1 will have an RO_num that cursor2 doesn't and vice-versa. Matching ro_nums will never have matching dates. The date in one cursor will always be higher than the other.

Any SQL statement that'll combine both cursors in one shot?

Thanks,

Marcel