All records from table A, corresponding records from table B

[betheball]

Table A is an employee table. Table B is an attendance table that shows that reflects hours worked by employee on a given day. However, if an employee doesn't work on a given day, there is no record for that employee in the attendance table on that day. Herein lies the problem. I want a query that for a given day shows the hours worked for each employee. I get all employees that worked at least one hour, but I need it to return even those who didn't work with a null value for the hours worked.

 

[Michael J Ross]

Create a query with a left outer join between Table A and table B