笔记213 inner join的问题

笔记213 inner join的问题

--inner join的问题
USE tempdb

IF  OBJECT_ID(N'#tb1')  IS NOT NULL
DROP TABLE #tb1
GO
IF  OBJECT_ID(N'#tb2')  IS NOT NULL
DROP TABLE #tb2
GO

CREATE TABLE #tb1(a INT ,b INT)
CREATE TABLE #tb2(a INT ,c INT)
GO

INSERT #tb1( a, b ) SELECT 1,2 ;
INSERT #tb2( a, c ) SELECT 1,3;
GO

SELECT * FROM #tb1
SELECT * FROM #tb2

SELECT t1.a ,t1.b,t2.c FROM #tb1 AS t1 INNER JOIN #tb2 AS t2 ON t1.a = t2.a