INNER MERGE JOIN : MERGE « Table Join « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Table Join
3. MERGE

3> SET NOCOUNT ON;
4> USE tempdb;
5> GO
Changed database context to 'tempdb'.
1> DROP TABLE dbo.T1, dbo.T2;
2> GO
1> CREATE TABLE dbo.T1(col1 INT PRIMARY KEY);
2> CREATE TABLE dbo.T2(col1 NUMERIC(12, 2) PRIMARY KEY);
3>
4> INSERT INTO dbo.T1(col1) VALUES(1);
5> INSERT INTO dbo.T1(col1) VALUES(2);
6> INSERT INTO dbo.T1(col1) VALUES(3);
7>
8> INSERT INTO dbo.T2(col1) VALUES(1.);
9> INSERT INTO dbo.T2(col1) VALUES(2.);
10> INSERT INTO dbo.T2(col1) VALUES(3.);
11>
12> SELECT T1.col1, T2.col1
13> FROM T1 INNER MERGE JOIN T2
14>   ON dbo.T1.col1 = dbo.T2.col1;
Warning: The join order has been enforced because a local join hint is used.
col1        col1
----------- --------------
          1           1.00
          2           2.00
          3           3.00