Different joins

[SqlHunter]

I have a DTs package to Build.

I have 2 servers as the source

Server1 has a database QAA and Table 1

Server2 has a database Tours and Table 1,Table 2,Table 3


Now I have a server3 with Database EMP with Table 1 as the Destination


In the Source ......Server1.QAA.Table 1 and Server2.Tours.Table1,Server2.Tours.Table2,Server2.Tours.Table3 are joined by a emp_id and the Server2.Tours.Table3 have multiple emp_ids So the dataset with the request_date as max should be pulled to the Destination.Please help me with this situation

 

[SqlHunter]

Please let me know if my doubt is not clear enough..