On Tue, Aug 4, 2009 at 11:38 AM, akm <[email protected]> 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? -- storm mailing list [email protected] Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/storm
