
March 18th, 2012, 10:18 AM
|
|
Registered User
|
|
Join Date: Nov 2010
Posts: 15
Time spent in forums: 4 h 45 m 32 sec
Reputation Power: 0
|
|
|
[Teradata]: Mutiple View definitions are not supported with WITH clause
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.
|