extract data from on table based on the values in a column in a different table
I have two tables. One table contains customer name and contact info. I have a second table that contains customer name, invoice numbers, job discriptions, date of service. I would like to take the second table and add the contact information from table 1 to each record (row) in the second table using the name as the common piece of data.
Anyhelp?
MacBook Pro 13″, macOS 10.14