Advertisement
Guest User

Untitled

a guest
Sep 17th, 2019
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. SELECT
  2. ANIMAL_OUTS.ANIMAL_ID,
  3. ANIMAL_OUTS.ANIMAL_TYPE,
  4. ANIMAL_OUTS.NAME
  5. FROM
  6. ANIMAL_OUTS
  7. INNER JOIN
  8. ANIMAL_INS
  9. ON ANIMAL_OUTS.ANIMAL_ID = ANIMAL_INS.ANIMAL_ID
  10. WHERE
  11. ANIMAL_INS.SEX_UPON_INTAKE LIKE 'Intact%'
  12. AND
  13. (
  14. ANIMAL_OUTS.SEX_UPON_OUTCOME LIKE 'Spayed%'
  15. OR
  16. ANIMAL_OUTS.SEX_UPON_OUTCOME LIKE 'Neutered%'
  17. )
  18. ORDER BY
  19. ANIMAL_ID
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement