Re: view-entity subquery WHERE clauses supported?

Posted by Christian Carlow-OFBizzer on
URL: http://ofbiz.116.s1.nabble.com/view-entity-subquery-WHERE-clauses-supported-tp4643984p4644042.html

The conditional join functionality is supported in the 12.04 release so
I'm switching to it rather than attempting to implement in 11.04.  The
conditional join functionality essentially accomplishes the same thing
that a subquery WHERE clause would.

On 09/16/2013 10:57 AM, Christian Carlow wrote:
> 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