We need to find how many Records will return in each join?
create and insert statements:
-----------------------------------------------
create table Table1 (id int)
insert into Table1 values(1),(0),(null),(1),(1),(null)
create table Table2 (Deptid int)
insert into Table2 values(0),(null),(null),(1),(1),(0),(null)