Search results

I want to perform a UNION of two tables, but occasionally the primary key field in each will have the same value while the rest of the row contains different data. In this case I want only the row from table1: table1 col1 col2 Frank blue Debbie red table2 col1 col2 George...