Is me again, I wondering why a simple 'join'sometine is n not good enough, and u will need to use left or right or other join?
See below thread to understand about the use of Joins, Keep and Concatenate
Understanding Join, Keep and Concatenate
check this document
Retrieving data ...