join conditions

[fmou]

Hi,

How can I specify join conditions in the join stage?

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

Thanks

[ray.wurlod]

No. The Join stage has only equi-joins on the identified join key columns.

[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

[fmou]

thanks everyone.