数据库多表查询问题

[fbCstrike]

我现在有两个表,table1,table2
table1有两个字段
UID Name
table2有很多字段
ID UID ..等
现在我要查询table2的记录并且显示UID对应的name
请问要怎么查询呢？

[colafei]

select B.UID, A.name
from table1 A, table2 B
where A.UID= B.UID

[水族杰纶]

select B.UID ,A.Name from table1 A inner join table2 B on A.UID=B.UID

[Shellbkboy]

[Quote=引用 1 楼 colafei 的回复:]
select B.UID, A.name
from table1 A, table2 B
where A.UID= B.UID
[/Quote]

[fbCstrike]

感谢两位