title: SQL How to compare data in two tables and get the results that are different between two tables
body: <p>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.</p>
  
  <p>I'm sorry if i did not explain the scenario accurately. I hope someone understands and answers this.</p>
  
  <p>thanks :) </p>