Hello, first I apologize if this has been answered already. I couldn't find the answer I need by doing a forum search.
Anyway, I have two similar tables. They both contain the same fields and some of the records may be identical. My question is what type of select statement do I need to use to find all of the records from both tables and not have any duplicates in the results. I have tried several different methods and none have returned the results that I need.