left join doesn't work correctly?

Tue, 30 Mar 2010 22:51:01 GMT

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?

topic left join doesn't work correctly? in QlikView

left join doesn't work correctly?