Page 1 of 1

join conditions

Posted: Wed Oct 19, 2011 11:48 am
by fmou
Hi,

How can I specify join conditions in the join stage?

translating from SQL, where should I put in the where clauses?

Thanks

Posted: Wed Oct 19, 2011 3:50 pm
by ray.wurlod
No. The Join stage has only equi-joins on the identified join key columns.

Re: join conditions

Posted: Wed Oct 19, 2011 4:05 pm
by SURA
As Ray siad you can't use join stage. But down the line you can add a filter stage / or if possible you can use a user defined query.

DS User

Posted: Thu Oct 20, 2011 12:42 pm
by fmou
thanks everyone.