Help with SQL JOIN

[hopkinsc]

Hi all,

I have a JOIN thats in SQL but i need to do the equivalent in QV but as a mapping load. 

My SQL isn't very good so i was hoping someone could help?

This is the JOIN 

JOIN (MNF_STKTHEORICPRODUCTION.CONTAINERTOID = OUTBOUNDORDERSTOCK.CONTAINERORIGINID AND OUTBOUNDORDERSTOCK.PARTIALCLOSEDSEQUENCE != NULL) OUTBOUNDORDERID
JOIN( OUTBOUNDORDERSTOCK.OUTBOUNDORDERID = OUTBOUNDORDER.ID) ACCOUNTCODE

any help would be appreciated. 

[rubenmarin]

Hi, a mapping table is created using two fields: [value to search] and [value returned].
You have to pass a [value to search] and it returns the [value retuned] of the same row.


What are the [value to search] and [value retuned] in that join?
https://help.qlik.com/es-ES/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes...