Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT PETS.NAME
- FROM PETS
- LEFT OUTER JOIN LOST_PETS
- ON PETS.PET_ID = LOST_PETS.PET_ID
- WHERE LOST_PETS.PET_ID IS NULL;
- SELECT *
- FROM pets LEFT OUTER JOIN pets-lost ON pets.id = pets-lost.id
- WHERE pets-lost.id IS NULL;
Add Comment
Please, Sign In to add comment