Christopher,
Not sure, but it is not adviseable to use a an b as aliases for your tables. Have not used Joins enough to find what else could be wrong.
Regards,
Marc
>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
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.