Query that includes NULL values

Hey guys,

Really really new to Access here.

Background

Currently using a collegue's access tool that allows me to RFC connect to SAP and download data from it.
This data is saved in another Access database.

Problem

I have 2 downloaded tables in my database:

Table 1 with data and codes.

Capture.JPG

Table 2 with explanations of these codes.

Capture2.JPG

I would like to make a query with information from table 1 and explain the codes of table 1 with table 2's information.
Important: columns SUBTY and ZZH2ROPMA of both tables are related.

In my query I do an inner join between the 2 tables for these columns.
Problem -> if a cell is empty in table 1 (see last row in screenshot) -> it doesn't appear in my query (due to the inner join).
I tried to do an other join, but I received an error (ambigious outer joins) when I tried to include all values of table 1 and only the matches of table 2.

Can anyone give me some advice?

Thanks a bunch!

screenshot of your quer in design view, to see how it linked. Make sure that both fields you are linking should be in same format. i.e Short Text, or Number.

That's great

Please close this thread, if you find the solution for your query.