create table A(col1 int, col2 char(1)) insert A select 1, 'a' union all select 1, 'b' union all select 1, 'c'create table B(col1 int, col3 char(1)) insert B select 1, 'A' union all select 1, 'B' union all select 1, 'C'select A.col1, A.col2, B.col3 from A inner join B on A.col1=B.col1 and A.col2=B.col3--result col1 col2 col3 ----------- ---- ---- 1 a A 1 b B 1 c C(3 row(s) affected)
create table A(col1 int, col2 char(1))
insert A select 1, 'a'
union all select 1, 'b'
union all select 1, 'c'create table B(col1 int, col3 char(1))
insert B select 1, 'A'
union all select 1, 'B'
union all select 1, 'C'select A.col1, A.col2, B.col3 from A
inner join B on A.col1=B.col1 and A.col2=B.col3--result
col1 col2 col3
----------- ---- ----
1 a A
1 b B
1 c C(3 row(s) affected)