[storm] join and subquery

[Brad Allen]

On Tue, Aug 4, 2009 at 11:38 AM, akm <a.km.mail at gmail.com> wrote:
> I have a query that looks like this: Is there any way to convert this to storm ?
>
>  SELECT *
>  FROM Table1 me
>  LEFT JOIN (
>                              SELECT MAX(crt_dt) crt_dt,
>                                     test_idn
>                              FROM Table2
>                              WHERE test_cd = 'Completed'
>                              GROUP BY test_idn)  inner_query1
>                   ON inner_query1.test_idn = me.test_idn
>  LEFT JOIN (
>                              SELECT MAX(crt_dt) crt_dt,
>                                     test_idn
>                              FROM Table2
>                              WHERE test_cd = 'Closed'
>                              GROUP BY test_idn)  inner_query2
>                   ON inner_query2.test_idn = me.test_idn

I noticed no one replied to this one; is this a limitation of Storm?