Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT t1.*
- FROM table1 t1
- INNER JOIN table2 t2
- ON t2.ID = t1.ID
- AND t2.NAME = t1.NAME
- AND t2.ADDRESS <> t1.ADDRESS
- SELECT DISTINCT t1.*
- FROM table1 t1
- INNER JOIN table2 t2
- ON t2.ID = t1.ID
- AND t2.NAME <> t1.NAME
- AND t2.ADDRESS <> t1.ADDRESS
- SELECT DISTINCT t1.*
- FROM table1 t1
- INNER JOIN table2 t2
- ON t2.ID <> t1.ID
- AND t2.NAME = t1.NAME
- AND t2.ADDRESS <> t1.ADDRESS
- Table 1 Table 2
- ID Name Address ID Name Address
- 0 Jim Smith 1111 A St 0 Jim Smith 2222 A St
- 1 Jim Smith 2222 B St 1 Jim Smith 3333 C St
- 0 Jim Smith 1111 A St
- 1 Jim Smith 2222 B St
- 0 Jim Smith 1111 A St
- 1 Jim Smith 2222 B St
- SELECT DISTINCT t1.*
- FROM table1 t1
- INNER JOIN table2 t2
- ON t2.ID = t1.ID
- AND t2.NAME = t1.NAME
- AND t2.ADDRESS <> t1.ADDRESS
- INTERSECT
- SELECT DISTINCT t1.*
- FROM table1 t1
- INNER JOIN table2 t2
- ON t2.ID = t1.ID
- AND t2.NAME <> t1.NAME
- AND t2.ADDRESS <> t1.ADDRESS
Add Comment
Please, Sign In to add comment