>Is there any particular reason why you don't prepare your data in VFP, copy it to a FOX2x Table and use that on in your Crystal Report ?

Yes. Users are able to run these reports without launching the VFP application. Also, it allows them to make a copy of the report and change it to their heart's desire.

>B.t.w. Did you have a look at the SQL designer ??

Yea. One thing that I failed to mention was that the two tables that I'm trying to use come from different ODBC data sources. From what I can tell, and I hope that I'm wrong, is that you can't use more than one data source in a given query file.

>>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.