Load data from Two or more Tables simultaneously

[Anonymous]

Hi, the idea behind my question is so simple, and I think that the solution will be so. I have two tables loaded from excels with different data and, to create a 3rd one I need to access on both simultaneously :

Table 1:   [Product Serial Number]

                [Failure Date]

Table 2:  [Product Serial Number]

               [Product Installation Date]

My aim is to create a 3rd table with the amount of time between [Failure Date] - [Installation Date] as a variable.

Nowadays my solution is to left joint table 1 and table 2 but what I want is to have It in separate if it is possible.

[Anonymous]

Yes, maybe It's that is not allowed. Thank You

[Anonymous]

If you achieve that after some time...you tag that in discussion.

Thnaq.