I want to perform a UNION of two tables, but occasionally the primary key field in each will have the same value. In this case I want only the row from table1:
table1
table2Code:col1 col2 Frank blue Debbie red
The result I want:Code:col1 col2 George brown Debbie orange
Code:col1 col2 Frank blue Debbie red George brown