ear Friends

I am describing my problem below, please send me some solution.

I have two DBF - EMPL.DBF and EMPSEC.DBF.
EMPL.DBF have three field - EMP_ID, EMP_NAME, EMP_ADDRESS and
EMPDESC have two field - EMP_ID, EMP_SECTION.

EMPL.DBF have 25 records out of them 3 are marked deleted and EMPSEC.DBF
have 10 records and 1 record is marked deleted and Both are joined with
EMP_ID field.

I like to write a query which show all the records from EMPL.DBF and joined
with EMPSEC.DBF but not the deleted records.

I have tried like the following but it didn't worked (may be syntax error)

Select a.emp_id, a.emp_name, a.emp_address, b.emp_section ;
from empl a, left join empsec b ;
where a.emp_id == b.emp_id and ;
not deleted(a) and ;
not deleted(b) ;
into cursor temp


Thank you

Aritra