AND OR Statement

[Khanson82]

I have this below..It is supposed to bring back a total of 3 for the count zip field. If you just use the getdate and statement, you get a total of 2 due to one of the fields being blank. If you use both the "and" and "or" you get 4???


SELECT a.ClientName AS Client, b.Zip AS ZipCode, COUNT(b.Zip) AS Zip
FROM dbo.Acc AS a INNER JOIN
dbo.vwa0 AS b WITH (nolock) ON a.ClientID = b.clientID
WHERE (b.StatusReason IN ('pending', 'reopen', 'reschedule', 'spanish pending'))
AND b.fudt <= getdate()
OR b.fudt = ('')

GROUP BY a.ClientName, b.Zip

 

[Khanson82]

Sorry guys, Just figured this one out.. No need to reply..

 

[gbaughma]

Post your solution; it may help others.



Just my 2¢

"What the captain doesn't realize is that we've secretly replaced his Dilithium Crystals with new Folger's Crystals."

--Greg

http://parallel.tzo.com

 

[Khanson82]

To fix my above problem, I put:

OR b.fudt is null

in place of :

OR b.fudt = ('')

And it worked great!