Convert MS-Access 2 joined queries to Oracle SQL?

How can I rewrite the following MS-Access queries for Oracle 7.3 sql? I don't know how to join the two queries?

This is the query that joins the 2 saved queries, and is the end result that I want:

SELECT qry_PEContact.EMPLOYEENAME AS PEContact, qry_Managers.GROUPDATA AS Manager
FROM qry_Managers INNER JOIN qry_PEContact ON qry_Managers.DEPTID = qry_PEContact.EMPLOYEEDEPTID;

Here is qry_PEContact:
SELECT TBLEMPLOYEES.EMPLOYEENAME, TBLEMPLOYEES.EMPLOYEEDEPTID FROM TBLEMPLOYEES; Here is qry_Managers:
SELECT TBLCBOCOMBO.GROUPDATA, TBLDEPARTMENTS.DEPTID FROM (TBLDEPARTMENTS INNER JOIN TBLEMPLOYEES ON TBLDEPARTMENTS.DEPTID = TBLEMPLOYEES.EMPLOYEEDEPTID) INNER JOIN TBLCBOCOMBO ON TBLEMPLOYEES.EMPLOYEENAME = TBLCBOCOMBO.GROUPDATA WHERE (((TBLCBOCOMBO.DIVISION)="NM") AND
((TBLEMPLOYEES.APPROVINGAUTHORITY)="True") AND
((TBLCBOCOMBO.GROUPTYPE)="NMContractMgr"));

Thanks for your help,
April Received on Wed Apr 10 2002 - 09:35:39 CDT