>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
Chris, try
SELECT a.ecode,b.ptitle,b.pacthrs,b.pdept ;
FROM tbl_ba_emp a left outer join tbl_ba_posmst b ;
ON a.eidno = b.eidno ;
INTO table tbltcst1 ;
ORDER BY eloc,ename
Note the syntax on the left outer join section.
HTH
Barbara