Advertisement
Guest User

Untitled

a guest
Mar 16th, 2019
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.32 KB | None | 0 0
  1. SELECT Matricule
  2. FROM PARCOURS_HE_SESS
  3. MINUS
  4. SELECT Matricule
  5. FROM PARCOURS_HE_SESS INNER JOIN MENTIONS ON (PARCOURS_HE_SESS.Mention=MENTIONS.Mention)
  6. WHERE PARCOURS_HE_SESS.AnSco <> 2005 AND PARCOURS_HE_SESS.Total =< 650 AND PARCOURS_HE_SESS.Sess <> 1 AND MENTIONS.Sess <> 2                                                                                   
  7. ORDER BY Matricule;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement