Simple query gone wrong?

[PureSlate]

Hi all,

I have a simple query here I was hoping somebody could look at. I created this query to pull only records from "GLHIST" which had no cooresponding record in "GLMAST."


SELECT GLHIST.* INTO GL
FROM GLHIST LEFT JOIN GLMAST ON GLHIST.[Account Number] = GLMAST.[Account Number]
WHERE (((GLMAST.[Account Number]) Is Null));

The query seems to be pulling everything instead. Anybody see what I missed?

 

[PHV]

What is the data type of [Account Number] in BOTH tables ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PureSlate]

Data type for both is text.

Found the problem I think, one was "#######" and the other was " #######". Spaces get me all the time.

 

[alvechurchdata]

You might try a sub query instead and get away from using Nulls:

SELECT GLHIST.* INTO GL
FROM GLHIST WHERE [Account Number] NOT IN 
(SELECT [Account Number] FROM GLMAST)

Geoff Franklin

http://www.alvechurchdata.co.uk