Hi,

the current thread about join remains me a question I already have, and
of course no real answer at this time.

Are there rules about join and where ?
Speaking of efficiency, what is better:
- put as lot as possible criteria in join clause and let where clause
with those which cannot be put in join
- put as lot as possible criteria in where clause and let join clause
with only fk
- it depends : some cases are better with first solutions, some are
better with second one ?

With another POV, are there some clauses we should always put in join
clauses ? are there some clauses we should never put in join clauses ?

(We will suppose our tables are correctly indexed: on criteria fields
and fk)

Thierry