求一段简单的SQL语句

[LWWL]

2个表
table1
A B
01 ASD
02 DFDF
02 SDF

table2
AA BB
01 大
02 小

通过语句后得到
BB A B
大 01 ASD
小 02 DFDF
小 02 SDF

[itblog]

select BB,A,B from table1 t1 inner join table2 t2 on t1.a=t2.aa

[xeqtr1982]

declare @t table(A varchar(10),B varchar(10))
insert into @t select '01','ASD'
union all select '02','DFDF'
union all select '02','SDF'

declare @a table(AA varchar(10),BB varchar(10))
insert into @a select '01','大'
union all select '02','小'

select BB,A,B from @t a,@a b where a.A=b.AA