[thelist] ASP.NET: UNION query not returning expected results

[Phil Turmel]

r937 wrote:
> SELECT O.id               AS OfficeID
>      , O.number           AS Office 
>   FROM dbo.Employees as E
> INNER
>   JOIN dbo.Offices as O
>     ON O.id = E.OfficeID
>  WHERE E.id = 57 
> UNION ALL
> SELECT O.id  
>      , O.number  
>   FROM dbo.Offices as O
> LEFT OUTER
>   JOIN dbo.Employees as E
>     ON E.OfficeID = O.id
>  WHERE E.OfficeID IS NULL 
> 
> 
> any questions, please just ask
> 
> ;o)
> 
Hi Joel, Rudy:

Sorry for jumping in late, but why have a union at all?

SELECT O.id
     , O.number
  FROM dbo.Offices as O
LEFT OUTER
  JOIN dbo.Employees as E
    ON E.OfficeID = O.id
 WHERE E.OfficeID IS NULL OR E.id = 57

                          ^^^^^^^^^^^^

HTH,

Phil