I have a data base of ip addresses. I need to come up with a way to bulk assign Host names to the available ip addresses. The only data that is the same between the two tables is a Farm Name which is the same for each record. My first query creates a temp table that lists ip addresses by farm name that do not have a host name. That is my data pool. Then I import from Excel a list of host names (with farm name) that need ip addresses. What I am not sure how to do is "Combine" the tables. Putting a Host Name with an IP address.