Hi

I have 2 tables

here's the tables

Users:
userid(int)
username(nvarchar)

calendar:
day(datetime)
userid (int)
exception (bit)

I want a list of users with the total exceptions, the problem is that if I do where exception = 1 the ones who don't have any event in the table calendar won't appear...

How can I do it...