General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SPT ...WHERE cCode IN (SELECT cCode FROM LocalTable)
(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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only