Select * from JobItems where ipkey in (Select ipkey From csrTempJobItems Where Deleted()=.T.)If I run the subquery by itself, I do get the desired results for the subquery, so I do not understand why it does not work in the full query shown above:
Select ipkey From csrTempJobItems Where Deleted()=.T.