>Hello, i have two tables and there are some matching records from one table to the other, i need to build a sql statement where displays only the records that does not match. How can i do this?
>
>Thanks for the support.

SELECT * FROM Table1;
       LEFT JOIN Table2 ON Table1.Key == Table2.Key;
       WHERE ISNULL(Table2.Key);
INTO CURSOR cBrowse

*** Other way

SELECT * FROM Table1;
       WHERE .NOT. Table1.Key IN (SELECT DIST Table2.Key FROM Table2);
INTO CURSOR cBrowse