How do I Join two tables, to a master table? Or Is there an easier way to import the data from other tables?

Hey Experts!
Can you help me please?

I have a few inventory tables in a database;
Table1 has columns: user name, pc asset number, laptop asset number, location and dept
Table2 has columns: Pc asset number, Dept. Computer name, serial number
Table3 has columns: Laptop asset number, Dept. Computer name, serial number

I would like to add a new column to Table1 called Dept. Computer Names

Now, without manually entering the 600 Dept. Computers names (600 units), is there away that I can Join / Import the Dept. Computer names from Tables 2 and 3, into Table1?

Also, can it be done by matching the correct Desktop/Laptop asset number (Table 2 & 3) to the correct user name? (Table1)

Please and Thanks !!!
Start Free Trial