Re: Urgent help
Date: 24 Jul 2003 13:09:23 -0700
Message-ID: <8156d9ae.0307240431.285195f4_at_posting.google.com>
(Not tested)
Example1:
Example2:
SELECT E.BucketID
, E.Time AS Empty
, H.Time AS Half
, F.Time AS Full
FROM (SELECT BucketID, Time
FROM BucketTable
WHERE WaterLevel = 'Empty'
) E
LEFT OUTER JOIN
(SELECT BucketID, Time
FROM BucketTable
WHERE WaterLevel = 'Half'
) H
ON H.BucketID = E.BucketID
LEFT OUTER JOIN
(SELECT BucketID, Time
FROM BucketTable
WHERE WaterLevel = 'Full'
) F
ON F.BucketID = E.BucketID
ORDER BY E.BucketID
;
SELECT E.BucketID
, E.Time AS Empty
, (SELECT Time
FROM BucketTable H
WHERE WaterLevel = 'Half'
AND H.BucketID = E.BucketID
FROM BucketTable F
WHERE WaterLevel = 'Full'
AND F.BucketID = E.BucketID
) AS Half
, (SELECT Time
) AS Full
FROM BucketTable E
WHERE WaterLevel = 'Empty'
ORDER BY E.BucketID
;
Received on Thu Jul 24 2003 - 22:09:23 CEST