Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have this SQL which I'm trying to replicate in Qlikview. How do I do outer joins in qlikview
select *
from gl_je_headers gjh,
gl_je_lines gjl,
ap_invoices_all aia,
po_vendors pv,
ap_invoice_distributions_all aida
where gjh.je_header_id = gjl.je_header_id
and aida.invoice_id(+) = gjl.reference_2 -- (how do I do this and the next two lines?)
and aida.distribution_line_number(+) = gjl.reference_3
and aida.invoice_id = aia.invoice_id(+)
and gjh.je_source = 'Payables'
regards
Mina