Hey all. I have a need to perform the old SELECT WHERE NOT IN sub-select from within Crystal Reports.

In VFP it's just:

SELECT x ;
FROM table1 ;
WHERE table1.x NOT IN ;
(SELECT table2.y FROM table2)

Any clues on how to accomplish this with CR?

Thanks.