Home Forums SQL Server 2008 SQL Server Newbies Filtering by StatusId RE: Filtering by StatusId
ryan.mcatee
SSC Eights!
Points: 860
More actions
March 12, 2013 at 1:00 pm
#1596240
No, you are not necessarily returning all instances where StatusId is null, just remove the last three lines:
...UNION
SELECT * FROM Employees
WHERE StatusId IS NULL