nested select in Join

[rtvt123]

I'm trying to execute the query below (self-join on table called table1), which works fine in mysql but throws an exception in phoenix, is there some syntax difference or is it just not supported yet?

select a.col1, b.col2
from (select * from table1 where col3='key') as a
JOIN (select * from table1 where col3 ='caption') as b
on a.rowkey=b.rowkey;

[rtvt123]

related issue:
"support derived tables": #5

[jaywong85]

https://github.com/forcedotcom/phoenix/wiki/Roadmap

all Available features I think them are all be commented by ' Available in master branch'

But Derived Tables haven't