Database Query Question

[bjr149]

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]

[bjr149]

figures it out already, user FULL OUTER JOIN on all joins to return everything

[oceanebelle]

gud for you. , now make this thread resolved.

[vb_dba]

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

Returns the same data, just looks a little cleaner with out all of the "OUTER" joins.