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.

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 November 6, 200817 yr by teratera