It cannot be done in one select. See Thread #626109 for discussion and solution.

>Dear 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