exclude query

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].NoDossi
er
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 problemHi
This will depend on the values of NoDossier that you have in the two tables!
You have 3000 matches but this could be (say) 2 distinct values for NoDossie
r.
John
"Fernand St-Georges" wrote:

> 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].NoDos
sier
> 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
>
>|||Fernand St-Georges
is this what you want?
SELECT
tblClient.*
FROM
tblClient
WHERE
tblClient.NoDossier NOT IN (
SELECT
NoDossier
FROM
[new table]
)|||Fernand St-Georges
is this what you want?
SELECT
tblClient.*
FROM
tblClient
WHERE
tblClient.NoDossier NOT IN (
SELECT
NoDossier
FROM
[new table]
)sql