A join statement that does not use an equality operation. The converse of this is the equijoin operation.
A join condition containing something other than an equality operator.
join statement that does not use an equality operation (i.e: colA colB). The converse of a nonequijoin is equi join.