Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

left join doesn't work correctly?

hello!

I have two tables in a access database:

1- inv
2- pnp

I made a simple query with those tables:

load *;
SELECT
inv.*, pnp.*
FROM inv LEFT JOIN pnp on
inv.invoice_num = pnp.[Invoice Number] and
inv.vendor_code=pnp.[Supplier Code] and
format(inv.invoice_date,'m/d/yyyy')=format(pnp.[Invoice Date],'m/d/yyyy');

At ms_access the result are ok: all data of table 1 and values from table 2 when conditions were matched.

This equal query in qlikview, showed me only values matched between table 1 & 2.
I need all values from table 1, as well as I have on access query.

Could you help me?

0 Replies