连接查询问题!!??????

[llss11]

我有两个表A1,A2;
A1
1 a
2 c
3 b
A2
1 a
2 b
3 f
4 c

我打算从A1中查和A2相同的而且排序是A2的排序;
怎么查啊,请指教!!!

[点点星灯]

select a.*,b.* from A1 a left join A1 b on a.id=b.id

[vivianfdlpw]

select A1.*
from A1
join A2 on A1.关联字段=A2.关联字段
order by A2.关联字段

[llss11]

字段是
ID 和 Name

[点点星灯]

declare @A1 table(id int,kk varchar(20))
insert @A1 values(1,'a')
insert @A1 values(2,'c')
insert @A1 values(3,'b')

declare @A2 table(id int,kk varchar(20))
insert @A2 values(1,'a')
insert @A2 values(2,'b')
insert @A2 values(3,'f')
insert @A2 values(4,'c')



select a.*,b.* from @A2 a left join @A1 b on a.id=b.id

[llss11]

关联字段是name 不是id

[点点星灯]

id kk id kk
----------- -------------------- ----------- --------------------
1 a 1 a
2 b 2 c
3 f 3 b
4 c NULL NULL

[点点星灯]

declare @A1 table(id int,name varchar(20))
insert @A1 values(1,'a')
insert @A1 values(2,'c')
insert @A1 values(3,'b')

declare @A2 table(id int,name varchar(20))
insert @A2 values(1,'a')
insert @A2 values(2,'b')
insert @A2 values(3,'f')
insert @A2 values(4,'c')

select a.*,b.* from @A2 a left join @A1 b on a.name=b.name

[llss11]

兄弟不用存储过程可以吗??
select distinct a.name from a join b on a.name = b.name order by b.name desc
这样写出错了

[vivianfdlpw]

select A1.*
from A1
join A2 on A1.name=A2.name
order by A2.id

[llss11]

我查的只是name 一个字段不是都查出来,怎么办

[vivianfdlpw]

select A1.name
from A1
join A2 on A1.name=A2.name
order by A2.id

[huang2005]

select *from a1,a2
where a1.id=a2.id
order by id

[llss11]

select A1.name
from A1
join A2 on A1.name=A2.name
order by A2.id

这种方法是可以但是加distinct就不对了