表A
sid sid_name
1 A1
2 B2
表2
pno pno_name
101 A101
102 B102
103 C103
希望得到结果
sid sid_name pno pno_name
1 a1 101 A101
1 a1 102 B101
1 a1 103 C101
2 B2 101 A101
2 B2 102 B101
2 B2 103 C101
sid sid_name
1 A1
2 B2
表2
pno pno_name
101 A101
102 B102
103 C103
希望得到结果
sid sid_name pno pno_name
1 a1 101 A101
1 a1 102 B101
1 a1 103 C101
2 B2 101 A101
2 B2 102 B101
2 B2 103 C101
insert into t1 select 1,'A1'
insert into t1 select 2,'B2'
create table t2(pno int,pno_name nvarchar(10))
insert into t2 select 101,'A101'
insert into t2 select 102,'B102'
insert into t2 select 103,'C103'
go
select * from t1,t2
/*
sid sid_name pno pno_name
----------- ---------- ----------- ----------
1 A1 101 A101
1 A1 102 B102
1 A1 103 C103
2 B2 101 A101
2 B2 102 B102
2 B2 103 C103(6 行受影响)
*/
go
drop table t1,t2