Robin2706

SQL justification

Mar 18th, 2016
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.47 KB | None | 0 0
  1. /* Ceci ... [586 lignes] */
  2. SELECT C.award_cat_id, T.award_type_id
  3. FROM Award_categories AS C, Award_types AS T
  4. WHERE C.award_cat_typeid = T.award_type_id;
  5.  
  6. /* ... donne presque le même résultat que cela. [589 lignes] */
  7. SELECT DISTINCT C.award_cat_id, T.award_type_id
  8. FROM Awards AS A, Award_categories AS C, Award_types AS T
  9. WHERE A.award_typeid = T.award_type_id AND A.award_catid = C.award_cat_id;
  10.  
  11. /* Je suppose que le premier est sous-ensemble du deuxième */
Advertisement
Add Comment
Please, Sign In to add comment