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 ==================================================================================================== =