Convert QUERIES from ORACLE to ACCESS!?!

[jas0214]

I created a database in Oracle iSQL, but now I have to make it work in Access. I was able to move everything over fine except for two queries. I know Access doesn't allow NATURAL JOIN or (+) but I'm not sure how to rewrite the statements to make them work.



First One:

select EMP_SSN, EMP_FNAME &" "& EMP_LNAME as "Employee Name",ins_dep_fname,ins_dep_dob

from employee e, insured_dependent i
WHERE e.EMP_ID = i.EMP_ID(+)
ORDER by EMP_FNAME;



Second One:

select EMP_FNAME &" "& EMP_LNAME as "Employee Name", EMP_SSN, EMP_ID_MANAGER

from employee NATURAL JOIN department;


Any help would be greatly appreciated!

[June7]

Something like:

SELECT EMP_SSN, EMP_FNAME &" "& EMP_LNAME as "Employee Name", ins_dep_fname, ins_dep_dob
FROM employee INNER JOIN insured_dependent ON employee.EMP_ID = insured_dependent.EMP_ID
ORDER by EMP_FNAME;

SELECT EMP_FNAME &" "& EMP_LNAME as "Employee Name", EMP_SSN, EMP_ID_MANAGER
FROM employee INNER JOIN department ON employee.department=department.department;

Don't know if the INNER join is correct for your situation. Maybe LEFT or RIGHT will be more appropriate.

[orange]

I think first example with (+) is Oracle Outer Join
see http://www.1keydata.com/sql/sqlouterjoin.html for example

for Access
see http://www.w3schools.com/sql/sql_join_left.asp