I have two tables
table_1
| number | type | name |
|---|---|---|
| 12 | 1 | steve |
| 12 | 2 | smith |
| 12 | 2 | jack |
and so on....
similiarly for
table_2
| number | type | name |
|---|---|---|
| 12 | 1 | abraham |
| 12 | 2 | jack |
| 12 | 2 | smith |
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?
Read more here: https://stackoverflow.com/questions/66282034/join-on-two-table-based-on-condition
Content Attribution
This content was originally published by pavan sai at Recent Questions - Stack Overflow, and is syndicated here via their RSS feed. You can read the original post over there.