Introduction
Home Comparison
Converting Objects
Table View Stored Procedure Datatypes
Converting SQL
SELECT Statement INSERT Statement UPDATE Statement MERGE Statement DELETE Statement Column Alias QUALIFY Clause

Roboquery

My Account
Home

Log in

Bookmarks

Profile

Sign up

Log out

Home » Guides
      Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Convert UPDATE statements from Teradata to BigQuery - Migration Guide

The order of the SET and FROM clauses is reversed in the UPDATE syntax

TeradataBigQuery equivalent

UPDATE t1
FROM t1, t2
SET
b = t2.b
WHERE a = t2.a;

UPDATE t1
SET
b = t2.b
FROM t2
WHERE a = t2.a;

◀ Previous Tutorial
INSERT Statement
Next Tutorial ▶
MERGE Statement



Post Comment