Regarding the query optimization, only the first join is needed, it ensures you are only taking the Source items that are also found on Target. The second one is not...