to all guru
im using postgres as my database and i have this query
select o. ,u. ,
TO_CHAR (o.created_on, 'MM/DD/YYYY') as date_ordered
from orders o ,users u
left join on (o.loan_officer_id = u.user_id)
where orders.order_id = 911 and
o.loan_officer_id = u.user_id
And i get an error
ERROR: syntax error at or near "on" at character 137
