Jump to content

teratera

Member
  • Posts

    1
  • Joined

  • Last visited

  • Donations

    0.00 USD 
  • Country

    United Arab Emirates

Posts posted by teratera

  1. 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.

×
×
  • Create New...