如何加入TSQL [英] How to Join in TSQL

问题描述

我有两个表A和B，

表A.

I have two table A and B,

Table A.

col 1    col 2
Row1     A
Row2     A
Row3     A
Row4     A
Row5     A
Row6     A

表B.

Table B.

col 1    col 2
Row1     B
Row2     B
Row3     B

我需要以下输出

and I need following output

Row1     A
Row1     B
Row2     A
Row2     B
Row3     A
Row3     B

我该怎么做，高级中的thanx ...

how can I do this, thanx in advanced...

推荐答案

检查此

Hi ,
Check this

select tb1.Col1 , tb2.col2 from tableA  as tb1 Inner join
Tableb as tb2 on tb1.col1 = tb2.col1

SQL联接 [ http://blog.sqlauthority.com/2009 /04/13/sql-server-introduction-to-joins-basic-of-joins/ [

SQL Joins[^]
http://blog.sqlauthority.com/2009/04/13/sql-server-introduction-to-joins-basic-of-joins/[^]
Best Regards
M.Mitwalli

请检查以下示例....

Hi Check the Following Example ....

CREATE TABLE dbo.Tab1 (Col1 VARCHAR(10), Col2 VARCHAR(10))
CREATE TABLE dbo.Tab2 (Col1 VARCHAR(10), Col2 VARCHAR(10))

INSERT INTO dbo.Tab1 (Col1, Col2)
SELECT 'Row1','A'
UNION ALL 
SELECT 'Row2','A'
UNION ALL 
SELECT 'Row3','A'
UNION ALL 
SELECT 'Row4','A'
UNION ALL 
SELECT 'Row5','A'
UNION ALL 
SELECT 'Row6','A'

INSERT INTO  dbo.Tab2 (Col1, Col2)
SELECT 'Row1','B'
UNION ALL 
SELECT 'Row2','B'
UNION ALL 
SELECT 'Row3','B'


SELECT T2.Col1,T2.Col2  
FROM dbo.Tab2 T2 
UNION
SELECT T1.Col1 , T1.Col2
FROM dbo.Tab1 T1 
WHERE T1.Col1 IN (SELECT Col1 FROM dbo.Tab2)

这将对您有帮助....

It will helps u....

这篇关于如何加入TSQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！