Archives of the TeradataForum

Message Posted: Wed, 07 Aug 2013 @ 12:48:20 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Use below syntax:

     Replace  view sandbox.v as
     locking table sandbox.a for access
     locking table sandbox.b  for access
     select *  from dba_sandbox.a , dba_sandbox.b where sandbox.a.c1= sandbox.b.c2

Thanks,

Mahesh

	<Prev	Next>		<<First	<Prev	Next>	Last>>