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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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