lundi 31 août 2015

Select mismatch column values from database

I want to select and fetch all mismatch value of two table having same Column Name But Id, Name and City are different. I am Using Sql Server Management Studio

Table A:

id   Name   City

1    John   karachi

2    smith  Capetown

3     liza   Washington        

Table B:

id   Name   City

7    Grey   Dubai

8    Clarke  Texas

9     liza   Washington

OUTPUT:

7    Grey   Dubai

8    Clarke  Texas



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire