Apache Phoenix SQL Join Limitation when using sub-queries phoenix sql I have this query in Apache Phoenix SQL: select WO.* from ( select “nr_id”, “txt_commrcial_label” from “e_application” APP …