date

plonker

Registered User.
Local time
Today, 12:02
Joined
Mar 14, 2003
Messages
19
i have a query that looks to see if an item is available or not - my criteria is the date - if a product has an associated date due then it is not available - my problem is that the query returns all items, both those with a due date and those without one? i only want the available ones to return....
 
Select yourcolumns from yourtable where duedate is null
 

Users who are viewing this thread

Back
Top Bottom