left join still only includes data that is in both tables

[MaartenH]

hi, 

I gonna try to expain the situation: 

- I have Two tables:

A. Employe table, per period (all in one table; with primary key - Period & employee nr). 

B. list of company cars, per period (primary key : Period & employee nr). 

A contains every employee; list B only contains those with a company car. 

In A I merge the query with B; based on the primary key, and in the power query I see that some employees get "null" in the new colum (those who don't have a car); other get het license numberplate of there company car. 

so far so good. 

now when i make a visual; and select from A. the employee name and from A the merged colum "numberplate"; I only get to see the employee names with an actual numberplate; those who don't have a company car, are excluded from the visual. 

I thought an inner join would work, butt apparently it doesn't, 

Any help?

Kind regards,

[MaartenH · Accepted solution]

OMG, 

I had a filter in an other table, for car "brand", ofcourse people that don't have a car, don't have a carbrand as wel....

**bleep**...quite expensive afternoon for the company 🙂 

move along 🙂