From and Where Clause

Description

From: Specifies a list of source tables that supply values for assignment to target table columns.

Where: Introduces a condition that indicates what rows are updated.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

Statement

Before

After

Copy

UPDATE INV AS I
      SET I.LOCATION = S.STORENAME
      FROM STORE AS S
      WHERE I.STORENO = S.STORENO;

Snowflake

Statement

Before

After

Copy

UPDATE PUBLIC.INV AS I
      SET I.LOCATION = S.STORENAME
      FROM STORE AS S
      WHERE I.STORENO = S.STORENO;