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

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

Teradata	BigQuery 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