SimpleQuery: multiple join conditions and still set the join type

By Carlos Henriques on 24 May 2012
The simple query widget only allows to set the join type when the condition just have 2 attributes.
The simple query should have the same options if the condition has more than 2 attributes or variables.

Example:

SELECT *
FROM TABLE1
LEFT OUTER JOIN TABLE2 ON (TABLE2.ReferenceId = TABLE1.Id AND TABLE2.Something = @SomeVariable)

This is not the same as:

SELECT *
FROM TABLE1
LEFT OUTER JOIN TABLE2 ON (TABLE2.ReferenceId = TABLE1.Id)
WHERE TABLE2.Something = @SomeVariable


I can't do this with the simple query, and I'm forced to use the Advanced Query just to say that the condition is a Left Join and not a normal Join.
Carlos Freitas31 Aug 2011
Should be possible to define more than one field in the join condition. This will avoid writing a couple of  advanced queries, taking advantage of the performance tunning of the simple queries.

Merged from 'More than one field in simple query joins' (idea created on 2011-08-31 20:02:49 by Carlos Freitas), on 2014-01-24 13:24:47 by Gonçalo Borrêga
Helio Pimenta6 Feb 2013
A must feature

Merged from 'More than one field in simple query joins' (idea created on 2011-08-31 20:02:49 by Carlos Freitas), on 2014-01-24 13:24:47 by Gonçalo Borrêga
which version of outsystems is this implemented in? I am using outsystems 8 and i dont find it.
Hélio Dolores13 Mar 2015
Hi Thirupathi,

This feature is only available in version 9 (with the new "Aggregates").

Best,
Hélio