Re: Urgent help
Date: Mon, 28 Jul 2003 06:36:22 GMT
Message-ID: <3f24c465_at_news.comindico.com.au>
OR I should simplify my problem :
BucketID Time WaterLevel
The BucketID is primary key. The timing of all buckets are random, so the
1 9:00 Empty
1 10:00 Half
1 11:00 Full
2 9:20 Empty
2 10:00 Full
This table keeps the timestamp of the water level of the buckets.
I want to write a SQL statement to show the following :
For the BucketID 2, there is no time recording of 'HALF' full, then it is
null or blank.
BucketID Empty Half Full
1 9:00 10:00 11:00
2 9:20 10:00