New to Teradata

UDA
Enthusiast

New to Teradata

What is wrong with this SQL

UPDATE test.Summary1
SET test.Summary1.c1 = test.s_table.C1 and
test.Summary1.c2 = test.s_table.C2
WHERE test.Summary1.acc_nbr = test.s_table.AccessNbr ;
Tags (1)
2 REPLIES
Junior Supporter

Re: New to Teradata

New to Teradata or new to SQL?

You must remove the 'and' and use a comma ',' instead.

UPDATE test.Summary1
SET test.Summary1.c1 = test.s_table.C1 ,
test.Summary1.c2 = test.s_table.C2
WHERE test.Summary1.acc_nbr = test.s_table.AccessNbr ;

HTH.

Cheers.

Carlos.
Enthusiast

Re: New to Teradata

for both and thanks for query.