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