Hi Duncan,
On Mon, 06 Nov 2006 23:49:28 +1300
Duncan Groenewald <
duncangroenewald@...> wrote:
> Any suggestions as to why the following search clause fails to return
> any rows ?
The syntax is as follows:
select P.Description, D.StartDate, D.DueDate,D.PromToRelActual
from ProjectWBS P, ProjectWBSDetail D
where ProjectCode = '011'
and D.ID=P.ID
and D.PromToRelActual >= DATE '2006-11-01'
and D.PromToRelActual < DATE '2006-12-01'
order by D.PromToRelActual
Take care,
--
Stefaan
--
As complexity rises, precise statements lose meaning,
and meaningful statements lose precision. -- Lotfi Zadeh
---------------------------------------------------------------
Mckoi SQL Database mailing list
http://www.mckoi.com/database/To unsubscribe, send a message to
mckoidb-unsubscribe@...
