Hi,

Could someone suggest on how to achieve below?

Let's say I have two tables, both are views. I need to form a join between those in Teradata. This can be achieved using WITH clause for multiple view definitions in DB2. But the same is not supported in Teradata. Like this, I need to form 3 digit number of joins.

Could you please suggest an alternative for achieving this?

Thanks,
Shaila_g.