问个小问题，两张表中有相同字段，连接查询后如何取各自的值？用ASP。

[philipses]

a,b表中都有name字段，

set rs=conn.execute(select * from a,b where a.id = b.id order by a.id )

一般是valuers=("name"),但这样只有一个值。我怎样才能得到两个表中的name值？

[pengdali]

set rs=conn.execute(select a.name as name1,b.name as name2 from a,b where a.id = b.id order by a.id )

[yczzg]

select a.name as name1,b.name as name2,其它字段
from a,b
where a.id=b.id
order by a.id

[gmlxf]

set rs=conn.execute(select a.name as nameA,b.name as nameB from a,b where a.id = b.id order by a.id )

[chengbcd]

牛