anandupad

The sql below works as expected select q.hx_id , q.text from ( select prod_code, s.* from testdb.test_table s inner join testdb.test_table2 p on s.s1_fk=p.p1_sk ) q But the following SQL...