view-entity subquery WHERE clauses supported?

[Christian Carlow]

Does anyone know if it is possible to constrain joined view-entity 
subqueries with their own WHERE clauses?

For example:
select * from tbl1 left join (select * from tbl2 where tbl2.col1 = 
'someVal') tbl3 on tbl1.col1 = tbl3.col1