In a sample query as this:
SELECT * FROM TableA WHERE nKey IN (SELECT nKey FROM TableB)
Is there any limit on the maximum number of records returned by the IN clause (SELECT nKey FROM TableB)?
I have some strange things occurring when the number of records returned is > 200.
I have HXTT DBF v4.0
No limitation, you can try also SELECT TableA.* FROM TableA,TableB WHERE TableA.nKey=TableB.nKey .