|
|
Posted by Fernand St-Georges on 10/01/80 11:19
I have 16,000 rows in tblClient and 3000 rows in NewTable.
SELECT tblClient.*
FROM tblClient INNER
JOIN [New Table] ON tblClient.NoDossier <> [New Table].NoDossier
if I use = (equal) instead of <> (exclude), the query returns 3000 rows
when I use <> it returns 160000 rows,
if I try group by, the query bugs
what is my problem
Navigation:
[Reply to this message]
|