一个子查询的问题？？

[risingwolves]

两个表A，B，有uid做为关联
要查出A中每个人在B表中的记录，请问怎么写
select * from A where UID=(select UID,Name from B where UID=??)剩下的不会了

[friendlyFour]

select a.*,b.* from a join b on a.UID=b.UID where ...

[risingwolves]

select * from A as a,* from B as b where a.UID=b.UID这样行不行啊

[xing_gg]

内连接OK了

[sungcong]

select a.*,b.* from a join b on a.UID=b.UID

[risingwolves]

我想同时算出A表对应B 表中UID的记录数，要怎么写啊

[risingwolves]

不要沉了

[yx360]

select * from B where id in (select eid from A)

[risingwolves]

sql="select realname,max(id),max(score),max(barid),sum(score),sum(kill),sum(killed),max(gameDate),count(realname) from nclass group by realname order by sum(score) desc"

想在两个表里实现这个语句实现的功能！就是计算A表的UID在B表中UID的记录数及各列的总和，SUM和，这样要怎么写