Search results

  1. C

    UNION two tables with same primary key values

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

    UNION two tables with same primary key values

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

    UNION two tables with same primary key values

    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...
Back
Top Bottom