Im trying to use a sql statement to get all the records
of one table and matching records of another on a key but
im getting a syntax error on the "ON line"

I know I doing something stupid.. can anyone help..




select a.ecode,b.ptitle,b.pacthrs,b.pdept ;
from tbl_ba_emp a, tbl_ba_posmst b ;
left join ;
on a.eidno = b.eidno ;
order by eloc,ename ;
into table tbltcst1



Chris