search

forcedotcom / phoenix

BSD 3-Clause "New" or "Revised" License
558 stars 227 forks source link

nested select in Join #700

Open rtvt123 opened 10 years ago

rtvt123 commented 10 years ago

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 commented 10 years ago

related issue: "support derived tables": https://github.com/forcedotcom/phoenix/issues/5

jaywong85 commented 10 years ago

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