PDA

View Full Version : SQL in complex join



fconsult
09-24-2009, 12:56 PM
Guys, can I have a SQL in the complex join field? If the complex field is the WHERE condition, can't I have something like "field_a IN (SELECT field_b FROM table_c WHERE field_d = field_b)"? I've made some experiments, but ir has never worked.

wgorman
09-24-2009, 02:42 PM
The complex join must be specified in Metadata Formula syntax:

http://wiki.pentaho.com/display/ServerDoc2x/02.+Pentaho+Metadata+Formulas

Your best bet to create the behavior you are specifying might be to define a view in the database.

Will