>>Bottom line, I was just making sure I had not overlooked some obvious error in my syntax. However, I still see no reason why this should not work. I am going to try a more creative way later tonight.
>
>Let me know if you figurew out a way to do it. I blew most of an afternoon trying to get it to work...
No matter what I do, you have to use 2 queries. The first requires the NOFILTER to guarantee a true cursor is created. If you do not and just a filter is used, you get an error on the second query.
select empid from employee where deleted() into cursor crsIsDel nofilter
select * from customer where emp_num in (select empid from crsIsDel)
Mark McCasland
Midlothian, TX USA