[thelist] SQL - searching a history table

[Matt Warden]

thelist,

Suppose the following table structure:

WIDGET
----------------------------
id
status

WIDGET_STATUS
----------------------------
widgetid
status
date_updated

In english, I need the number of widgets with a widget status record
for status 'X' and date_updated within the range 01-MAY-2006 and
01-JUN-2006. The catch is that this must be the last update to the
status in that time period.

Any ideas? I have something close now, but I will refrain from
describing it to avoid boxing in creativity.


-- 
Matt Warden
Cleveland, OH, USA
http://mattwarden.com


This email proudly and graciously contributes to entropy.