Outer Joins

[ciarra41]

I’m trying to convert an Oracle outer join query into Access. But I’m getting fewer records with Access than Oracle. Any advice or examples would help.


Oracle
WHERE
( product.SERVICEid=SERVICE.SERVICEid(+) )
AND ( SERVICE.repid=employee.employeeid(+) )

Access
SELECT DISTINCT PRODUCT.SERVICEID, EMPLOYEE.EMPLOYEEID, SERVICE.REPID
FROM PRODUCT LEFT JOIN (SERVICE LEFT JOIN EMPLOYEE ON SERVICE.REPID = EMPLOYEE.EMPLOYEEID) ON PRODUCT.SERVICEID = SERVICE.SERVICEID;

 

[cmmrfrds]

Do you have more criteria in the where clause other than just the join?

 

[ciarra41]

Yes I do, about 5 other tables. I'm sure the problem lies in the product table because there's multiple serviceid in that table. I just need them to show even when their not in the service table.

 

[cmmrfrds]

Please show all your criteria for the Where Clauses in both queries.