Jump to content

SQL Query - need to return null values


Recommended Posts

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, EmpLastName
FROM OrderTbl JOIN Employee
ON OrderTbl.EmpNo = Employee.EmpNo
WHERE 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


SELECT OrdNo, OrdDate, Employee.EmpNo, EmpFirstName, EmpLastName

FROM OrderTbl JOIN Employee

ON OrderTbl.EmpNo = Employee.EmpNo

WHERE OrdDate = '01/23/07' or OrdDate IS NULL

Do not use ISNULL to find NULL values. Use IS NULL instead. Note the space between IS and NULL

http://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, EmpLastName
FROM OrderTbl JOIN Employee
ON OrderTbl.EmpNo = Employee.EmpNo
WHERE 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 by teratera
Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...