Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH join1 AS (
- SELECT * FROM table1
- INNER JOIN table2
- ON table1.userID=table2.userID
- ),
- join2 AS (
- SELECT * FROM table1
- INNER JOIN table3
- ON table1.userID=table3.userID
- )
- SELECT * FROM join1 INNER JOIN join2
- ON join1.userID=join2.userID
- WHERE join1.Entitlement <> join2.entitlement
Add Comment
Please, Sign In to add comment