> Are there rules about join and where ?

The rules are simple: join criteria are put into join, filter
criteria are put into where. Generally, same conditions in join and in
where used to produce different results.

SY, SD.