苦闷，再求sql语句

[missukiss02]

表A：字段：name，score，typeid
表B：字段：id，typeName
typeid和id是主关键关系。
想查询出的结果是：name，score，typeName
如何实现。谢谢

[dengchenlu]

SELECT * FROM A LEFT JOIN B ON A.typeid = B.id

[BernardSun]

select name,score,typeName from a,b where typeid =id

[使我做你和平之子]

select a.name, a.score, b.typeName from a inner join b on a.typeid = b.id

[tangjunping]

select name，score，typeName from A left join B on A.typeid=B.id
或者
select name，score，typeName from A,B where A.typeid=B.id

[missukiss02]

感谢你们。。。问题解决了

[chen_ya_ping]

select name ,score,typeName from A inner join B on A.typeid=B.id

[biaofanwo]

select name,socre,(select typeName from B b where a.typeid=b.id) typeName from A a