Recent content by carillonator

No, it returns both (Debbie, red) and (Debbie, orange). UNION only removes duplicates that are identical in all fields. I think I'm going to have to do a join for one side of the union.

When a name appears in both tables, I only want to return the row from table1. thanks

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...