2 Where clauses - is there a better way?

[matt_4013]

Hi there, I wrote this query

SELECT ShareHolderDet.ShareHolderID, ShareHolderDet.Surname, ShareHolderDet.GivenName, SUM( Transactions.Quantity ) AS TotalQuant
FROM ShareHolderDet
LEFT JOIN Transactions ON ShareHolderDet.ShareHolderID = Transactions.ShareHolderID
WHERE Transactions.ShareHolderID IS NULL OR Transactions.ShareHolderID IS NOT NULL 
GROUP BY ShareHolderDet.ShareHolderID

It does exactly what I want it to (Give the details of a ShareHolder, and the total count of the quantity of shares they hold), but I was wondering if there was an easier way to do it. It seems a bit strange that I would have to specify that I want both NOT NULL and NULL records. If I don't do that, then it doesn't return a row for Share Holders who don't actually hold any shares at that point in time.

Any ideas on an easier way to get it to show all the information that I require?

[tomhath]

Doesn't it run without any "WHERE" clause? Obviously the one you have doesn't do anything. The "ON" clause of the LEFT JOIN is all you should need.

[matt_4013]

Nope, if I run it without the where clause it just gives me the NOT NULL records 🙁