When I run my query as `INNER JOIN` between two tables, I get the correct result - 182 in all.

However, when I run the query as `LEFT JOIN`, I get only 8 records back. Am I performing the join incorrectly?

First the code:

```
select e.username,
       e.password,
       coalesce(r.access_level, 0) as orgid 
  from employees e 
       left join retired r 
           on e.employeeid = r.employeeid 
 where access_level=3

```

The `Retired` table has only 182 records. Both tables are related by `EmployeeId`.

The 82 records in `Retired` table also exist in `Employees` but `Employees` table has over 7 thousand records.

One of the fieldnames `Retired` is called `Access_Level` with a value of 3.

Any ideas why `LEFT JOIN` isn't giving me an accurate result?