footballking3420 Posted November 6, 2008 Share Posted November 6, 2008 I can't for the life of me remember how to return both null and non-null values in a SQL Query. I'll go ahead and post what I have:SELECT OrdNo, OrdDate, Employee.EmpNo, EmpFirstName, EmpLastNameFROM OrderTbl JOIN EmployeeON OrderTbl.EmpNo = Employee.EmpNoWHERE OrdDate = '01/23/07'I have two rows where the EmpNo is null, but there is still data I need to retrieve from it. Link to comment Share on other sites More sharing options...
teratera Posted November 6, 2008 Share Posted November 6, 2008 (edited) SELECT OrdNo, OrdDate, Employee.EmpNo, EmpFirstName, EmpLastNameFROM OrderTbl JOIN EmployeeON OrderTbl.EmpNo = Employee.EmpNoWHERE OrdDate = '01/23/07' or OrdDate IS NULLDo not use ISNULL to find NULL values. Use IS NULL instead. Note the space between IS and NULLhttp://technet.microsoft.com/en-us/library/ms184325.aspx=====================================================================================================I can't for the life of me remember how to return both null and non-null values in a SQL Query. I'll go ahead and post what I have:SELECT OrdNo, OrdDate, Employee.EmpNo, EmpFirstName, EmpLastNameFROM OrderTbl JOIN EmployeeON OrderTbl.EmpNo = Employee.EmpNoWHERE OrdDate = '01/23/07'I have two rows where the EmpNo is null, but there is still data I need to retrieve from it. Edited November 6, 2008 by teratera Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now