Join ON condition only works for EQUAL condition.

[demmings]

JOIN ON condition.

The join condition only works for equality (which is all I ever need - but whatever). The following select returns the derived table as if '=' had been used, but it was not. For example, the following select does not return the correct results:

select * from booksales join customers on booksales.customer_id <> customers.id