It's something like this:

SELECT 1
USE Table1
SET ORDER TO Address

SELECT 2
USE Table2
SET RELATIONSHIP TO Address IN Table1

SCAN
REPLACE LogicalField WITH IIF(Table2.Address = Table1.Adress, .T., .F.)
ENDSCAN

*************
When I first started programming and data analysis in the mid-1990's, I used to use a program like this all of the time. On very large tables (over 250,000 records), it worked quicker than SQL.


Jerry