I don't want to append the records together. I want to join them so that I can search. I have one database that has a customers Social Security number and some information. I have another table with the Customers Social Security number and other information. I need to search based on Socail Security number and only find those records that match. I don't want to merge them together but rather search.