Re: Urgent help

To all,

I am using MySQL so it does not support subquery.

"Tokunaga T." <tonkuma_at_jp.ibm.com> wrote in message news:8156d9ae.0307240431.285195f4_at_posting.google.com...
> (Not tested)
>
> Example1:
> 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
> ;
>
> Example2:
> SELECT E.BucketID
> , E.Time AS Empty
> , (SELECT Time
> FROM BucketTable H
> WHERE WaterLevel = 'Half'
> AND H.BucketID = E.BucketID
> ) AS Half
> , (SELECT Time
> FROM BucketTable F
> WHERE WaterLevel = 'Full'
> AND F.BucketID = E.BucketID
> ) AS Full
> FROM BucketTable E
> WHERE WaterLevel = 'Empty'
> ORDER BY E.BucketID
> ;
Received on Thu Jul 24 2003 - 23:31:50 CDT