See
Re: Slow SQL Statement Message #
1074619>I know this is quite simple, bu can't seem to get it!
>
>I need to create a cursor from 2 tables, both having identical fields (e.g. name) in such a way that the selected records from the left table should not be present in the right table. i.e. do not select the same name from the right table, if it is present in the left table.
--sb--