JOIN criteria need to be ANDed together
Explicit in docs re: ANSI SQL support/preference