PowerBI will create an inner join between the two tables if I drag columns from two tables?

[wzwd2023]

I have Table A that has one column SKU and Table B that has two columns SKU and Qty.

I want to show qty of SKUs that in Table A. I will get qty from Table B.

SKU

A

B

C

D

Table A

SKU	Qty
A	13888
B	2916
C	11

Table B

Ideally, the table visual in power bi should be

SKU	Qty
A	13888
B	2916
C	11
D

however, I got the results below. 

Can someone please explain why and how can I get the results I want?

Thanks

[Padycosmos · Accepted solution]

Hope this helps