1821 shaares
For INNER JOIN, WHERE predicates and ON predicates have the same effect.
For OUTER JOIN, WHERE predicates and ON predicates have a different effect.
Remplacer NOT IN soit par NOT EXIST ou un left outer join where NULL
For INNER JOIN, WHERE predicates and ON predicates have the same effect.
For OUTER JOIN, WHERE predicates and ON predicates have a different effect.
Remplacer NOT IN soit par NOT EXIST ou un left outer join where NULL