There are 2 tables. Table a and b. A contains msisdn, firstname, secondname, lastname, regdate(registration data). Table b also has the same fields. I want to compare these two tables, the msisdn's, firstname and lastname fields. If msisdn X in table A has firstname as jim and lastname as halpert, and the same msisdn X has firstname as michael and secondname as scott in table B, i need to get these kinds of msisdn's as my query result. the one's with same msisdn in both tables and different names. if either of these names(first or last) mismatches, that should be shown as result.
I'm sorry if i did not explain the scenario accurately. I hope someone understands and answers this.
SELECT A.*, B.* FROM TABLEA A INNER JOIN TABLEB B ON A.MSISDN = B.MSIDN WHERE A.firstname != B.firstname OR A.lastname != B.Lastname