table question

C

coconutt

Hi, I have 2 tables with the same fields, patient demographics. one is older
then the other as far as parameters,(1)is it possible to run a query that can
pull the names that are not duplicates in both tables(2)can a query tell me
wich table the name came from?

Thank you
 
Top