>SELECT * FROM TableA WHERE tableA.id IN (SELECT id FROM TableB) >>The query usually worked fine and returned the desired results, but it apparently corrupts some memory. After running this SQL multiple times (in my testing, as few as 2 times and as many as 290 times) eventually a subsequent command causes a C5 and sometimes a VFP error, Error # 43-There is not enough memory to complete this operation. Most times (but not always), the vfp8err.log is updated and references the object, method and line number of the code that was executing - but that really wasn't all that helpful (in fact, misleading) because it only referenced the subsequent command and not SQL that caused the problem.