Selected tables
CREATE VIEW
FROM
WHERE
Show Columns
Selected tables
CREATE VIEW
FROM
WHERE
Show Columns
Selected tables
Use this field to select a table name after clicking on the Show Columns push button. This field displays the names of the tables that you have selected for the join.
CREATE VIEW
Type the SQL CREATE VIEW statement for the join of the replication sources.
CREATE VIEW:
Example
USERID.VIEW_NAME AS SELECT A.col1, A.col2, B.col6, B.col5
Attention: Do not type the literal phrase, CREATE VIEW. It is supplied by the Control Center.
FROM
Type the SQL FROM statement for the join of the replication source.
FROM:
Example
TABLEA A, TABLEB B
WHERE
Type the SQL WHERE clause for the join of the replication source.
WHERE:
Example
A.col1=B.col1
