Sign in to follow this  
Followers 0
footballking3420

SQL Query - need to return null values

2 posts in this topic

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.

0

Share this post


Link to post
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
0

Share this post


Link to post
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
Sign in to follow this  
Followers 0

  • Recently Browsing   0 members

    No registered users viewing this page.