when two tables in a join query have only a single join condition

when two tables in a join query have too many join conditions

This is hard to determine.

when two tables in a join query have no join condition