Posted by Alexander Kuznetsov on 12/05/65 11:33

oops I meant

3.
select c.left_PK
from left_table c left outer join right_table t
on c.left_PK=t.left_PK
where t.RIGHT_PK is null

• Next in forum: Re: STORED PROCEDURE - passing table name as a parameter
• Prev in forum: Re: Indexing and Queries
• Thread view: Re: Indexing and Queries

[Reply to this message]