There is incorrect SQL in the documentation:
From the documentation:
SELECT o.* FROM NW.orders o join NW.customers c join o.customer_id = c .id where c .id=1234 and o.orderdate > {ts '2012-12-31 21:23:38' }
Correct SQL
SELECT o.* FROM NW.orders o join NW.customers c on o.customer_id = c .id where c .id=1234 and o.orderdate > {ts '2012-12-31 21:23:38' }
Documentation URL: https://docs.jboss.org/author/display/TEIID/OData+Support