Skip to content

Instantly share code, notes, and snippets.

@marquinhosoliveira

marquinhosoliveira/LEFTEXCLUDINGJOIN.SQL

Created April 18, 2019 00:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marquinhosoliveira/11ae3be1ac5d4c07ab2bb44e111dbcea to your computer and use it in GitHub Desktop.
Save marquinhosoliveira/11ae3be1ac5d4c07ab2bb44e111dbcea to your computer and use it in GitHub Desktop.
Download ZIP
TODAS AS MULHERES QUE NÃO TEM FILHOS
Raw
LEFTEXCLUDINGJOIN.SQL
SELECT MULHER.NMMULHER, FILHO.NMFILHO FROM
MULHER LEFT JOIN FILHO ON
MULHER.IDMULHER = FILHO.IDMULHER
WHERE FILHO.IDMULHER IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment