Am 17.10.2012 13:47, schrieb Nols Smit: > Hi, > > I have a table, let's call it TENDERS. It has the following fields: ID, > Date_Closing, Value (ID is the pimary key). > > How do I select the the records in TENDERS where either Date_Closing or Value > or both is null but also including those records where Date_Closing is not > null and Date_Closing is between DateA and DateB and Value is null ?
select * from TENDERS where (Date_Closing is null) or (Value is null) (the condition "Date_Clooing is not null and Date_Closing is between DateA and DateB and Value is null" is already included in "Value is null") Too simple to be correct. -- Magnus