[帖]使用SQL代码来完成两个数据表的整合

if object_id('[TB1]') is not null drop table [TB1]gocreate table [TB1] (stu_id int,stu_class int,stu_name nvarchar(4))insert into [TB1]select 1001,2,'小张' union allselect 1002,3,'小王' union allselect 1003,7,'小赵'--> Title  : Generating test data [TB2]--> Author : --> Date   : 2011-10-20 08:10:10if object_id('[TB2]') is not null drop table [TB2]gocreate table [TB2] (stu_grade int,stu_id int,stu_mobile bigint)insert into [TB2]select 1,1001,13712345678 union allselect 3,1002,13798765432 union allselect 2,1003,13365465891select * from [TB1]select * from [TB2]SELECT TB2.stu_id,TB2.stu_grade,TB1.stu_class,TB1.stu_name,TB2.stu_mobileFROM TB2INNER JOIN TB1 ON TB2.stu_id = TB1.stu_id/*stu_id      stu_grade   stu_class   stu_name stu_mobile----------- ----------- ----------- -------- --------------------1001        1           2           小张       137123456781002        3           3           小王       137987654321003        2           7           小赵       13365465891(3 行受影响)*/