Hi team,   when i am trying to run below query    select b.proc,b.yr,b.RCNT from table2 b WHERE length(b.PROC)=5 AND (b.ytype='1' or b.PROC IN (SELECT c.tet FROM table1 c));   getting an error like this: ERROR: AnalysisException: Subqueries in OR predicates are not supported:    can anyone help me in this ? ... View more