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.