I have two tables
and so on....
Here i am doing inner join and i need output as where there is mismatch in name when number and type is equal. My query is
select * from table1,table2 where table1.number=table2.number and table1.type=table2.type and table1.name <> table2.name
But the output shows for type '2' smith jack and jack smith as well which i dont want.can anyone help me?