(VFP6) I want to do an SPT query like

SELECT LotsOfData FROM GiantServerDatabase ;
WHERE GiantServerTable.Code ;
IN (SELECT cCode FROM LocalTable)

to avoid pulling back so many records and then throwing out the ones I don't want. The LocalTable has 57 codes, and at 20+ minutes per query, I don't want to loop through my 57 codes and do 57 parameterized queries.

This is data for a report which will be run monthly.

Any advice? Thanks.