Hi I want to know how best to deal with load order wherein I am carrying out joins to a main table then using the resultant table to carry out another join, then using the resultant table of that to carry out the next join and so on. So for instance I have the following:
LOAD * FROM TABLE A
LEFT JOIN (A)
LOAD * RESULTANT TABLE
LEFT JOIN (RESULTANT TABLE )
LOAD * NEXT RESULTANT TABLE
LEFT JOIN ( NEXT RESULTANT TABLE )
Please let me know in case it doesnt make sense but essentially carrying out join to a table then using the result of that to carry out the next join and so on ...
Ok just to be clearer this is what I'm trying to do.
I have one main table and then a separate exceptions list both of which contain the field 'Contract_ID. What I'm trying to do is effectively say if the contract ID is not on the exceptions list ie it doesnt match on Contract_ID then lookup these Contract IDs to a further mapping.
Likewise if they do match then again map to a separate mapping.