Is this a join of some sort?

qlikmpate0 — Thu, 06 Aug 2015 08:22:22 GMT

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

topic Is this a join of some sort? in QlikView