I have 3 tables
TABLE: EMP
PK - EMP-ID
- EMP-NAME

TABLE: ALTER
PK - EMP-ID
FK - EMP-ALTERNATE

TABLE: LIMIT
PK - EMP-ID
- EMP-LIMIT

And im trying to show every instance on the employees table.
I've got my query to work fine with 2 tables but i cannot get it to work with three.

this query returns only the instance where data exist in all three tables for the empID, if its not in each table it doesnt print it. This is my query .


SELECT dbo.EMPLOYEES.[emp-id], dbo.EMPLOYEES.[emp-name], dbo.[EMP-ALTERNATE].[ALTER-APPROVER], dbo.[EXC-LIMIT-ID].[EXC-LIMIT-AMT]
FROM dbo.EMPLOYEES RIGHT OUTER JOIN
dbo.[EMP-ALTERNATE] ON dbo.EMPLOYEES.[emp-id] = dbo.[EMP-ALTERNATE].[ALTER-ID] OUTER JOIN
dbo.[EXC-LIMIT-ID] ON dbo.EMPLOYEES.[emp-id] = dbo.[EXC-LIMIT-ID].[EXC-LIMIT-NUM]