Posted by Alexander Kuznetsov on 10/02/32 11:47

*UNTESTED*

select ...
from table1 join table2 on table1.id1 > table2.id2
and not exists(select 1 from table2 t2 where table1.id1 > t2.id2 and
t2.id2>table2.id2)

• Next in forum: Need OLAP Dev in Colorado
• Prev in forum: Exotic SQL Question
• Thread view: Re: Exotic SQL Question

[Reply to this message]