lundi 24 août 2015

Join on two table with same primary key but different data

I am trying to join two tables that are identical in structure. I want my join to choose the data from second table if row for same primary key exist in both. For instance, if I have the following tables with data -

enter image description here enter image description here

I want join to give me something like this -

enter image description here

Any help would be really appreciated. Thanks

Aucun commentaire:

Enregistrer un commentaire