Kbase P98234: How query Progress for a blank date field using the SQL-89?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/04/2005 |
|
Status: Unverified
GOAL:
How query Progress for a blank date field using the SQL-89?
FACT(s) (Environment):
Progress 8.x
Progress 9.x
FIX:
The following SELECT statement uses the 'IS NULL' phrase to list customers whose orders have not been shipped yet:
SELECT Name, City, State, Order-Date
FROM Customer, Order
WHERE Ship-Date IS NULL.
The following SELECT statement uses the 'IS NOT NULL' phrase to list customers whose orders have already shipped:
SELECT Name, City, State, Order-Date
FROM Customer, Order
WHERE Ship-Date IS NOT NULL.