Hello all
We need to run a query to generate a list of any active table1.dbf records with table1.x1 fields that have data in the x1 fields with no matching x1 in the table2 table.
I submitted the query should be
SELECT d.userid, d.x1
FROM table1 d
WHERE d.active
AND !EMPTY(d.x1)
AND d.x1 NOT in (select x1 FROM table2) ORDER BY 2
My co-worker says this is wrong.
who is right?
thanks
The American Republic will endure, until politicians realize they can bribe the people with their own money.
- Alexis de Tocqueville
No man’s life, liberty, or property is safe while the legislature is in session.
– Mark Twain (1866)