>QUESTION ABOUT COMPARING 2 TABLES
>
>I HAVE TABLE1 WITH 24 LOGICAL FIELDS (100 RECORDS)
>
>I HAVE TABLE2 WITH A FEW OF TABLE1'S LOGICAL FIELDS SET TO .T.
>(200 RECORDS)
>
>I WHATS THE BEST WAY TO COMPARE THE TWO TABLES AND KNOW WHEN THERE IS A MATCH AND HOW MANY I AM MISSING WHEN THERE IS NOT A MATCH?
>
>THANKS FOR HELP,
>
>DON C.

I am not sure if it gives you the right result.

Try:

To get records that matches True:

SELECT * FROM Sample1 WHERE log IN (SELECT * FROM sample2 WHERE log )  

To get records that matches False:

SELECT * FROM Sample1 WHERE log NOT IN (SELECT * FROM sample2 WHERE log )