it might help if you provided a few lines of data from each table to help illustrate the issue.
It sounds like you'll need to maybe do something like:
Load Table 2
Load Table 3
Set up mapping table based on Table 3
Load Table 1 where your key exists in Table 2, and also maybe where the results of the Table 3 mapping are ok