K
kingaustin
I need to conduct a query on several tables and have the output merge
the collected dated into a colomn of a third table.
It is a DB of names, companies, and email addresses.
There are 3 tables A,B, and C.
A: table of companies and names
B: table of companies, different names and emails
C: NEEDS to be a table of companies, some selected names, and emails
for a select few
1) I need to match A and B based by company and their job titles. Then
I need to search through B and find which people with the particular
job title have an email recorded in the B table.
2) Then I need to take those emails and push them into an email column
in my C table that has all the names from both A and B but no emails
for the particular job titles.
I have already set up a query that does (1) but I dont know how to make
(2) happen.
Thanks
the collected dated into a colomn of a third table.
It is a DB of names, companies, and email addresses.
There are 3 tables A,B, and C.
A: table of companies and names
B: table of companies, different names and emails
C: NEEDS to be a table of companies, some selected names, and emails
for a select few
1) I need to match A and B based by company and their job titles. Then
I need to search through B and find which people with the particular
job title have an email recorded in the B table.
2) Then I need to take those emails and push them into an email column
in my C table that has all the names from both A and B but no emails
for the particular job titles.
I have already set up a query that does (1) but I dont know how to make
(2) happen.
Thanks