Oracle Forms

I have 2 tables:PERSDET and EMP_MEDICAL_LTA
PERSDET has EMP_ID,EMP_NAME n some other fields.
EMP_MEDICAL_LTA has EMP_ID,FIELD1,FIELD2 n some other fields
EMP_ID is the common field between these 2 tables.

My requirement is to display all the EMP_NAME,that is-EMP_NAME which have field1 and field2 entries, as well as EMP_NAME which donot have field1 and field2 entries. I thought of using a LEFT join for this operation. The query I used is as follows:

SELECT PERSDET.emp_id,PERSDET.emp_name,EMP_MEDICAL_LTA.field1,EMP_MEDICAL_LTA.field2 into emp_id,emp_name,m,l FROM
PERSDET LEFT JOIN EMP_MEDICAL_LTA ON PERSDET.emp_id=EMP_MEDICAL_LTA.EMP_ID
where …<some other joining conditions>;

This query worked perfectly fine when I tried it running on the SQL prompt, but when I wrote it in a cursor in Oracle Forms 6i, it gave an error on the “LEFT” keyword!

Is there any substitute for LEFT JOIN in Oracle Forms 6i???

Please help!

Thanks!