Re: dumb question

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 6/2/2016 11:10 AM, Steve Clark wrote:

Thanks all the below seem to do the trick.

On 06/02/2016 01:58 PM, David G. Johnston wrote:

select max(id) from yourtable where sts=0 and id not in (select ref_id from yourtable);

select max(id) from yourtable where sts=0 and id not in (select ref_id from yourtable);

do note, this is whats known as an 'anti-join', and these can be pretty expensive on large tables.  

-- 
john r pierce, recycling bits in santa cruz