实现下面的功能
表1
room
roomid
roomname
表2
roominfo
roomid
member_name
实现下面功能:
请问如何将俩个表中的数据查出来
1、查出room表里面的id_name,id,和第二个表里面的同一ID的所有人数就是count(*)但要是同一ID
strsql:='select s.roomname,s.roomid t.count(*) from qq_room s, roominfo t where s.roomid=t.roomid'本人这样写有问题，应该如何修改
问题点数：50、回复次数：7Top
1 楼lsp5i5j（星辰->女人在哪）回复于 2005-07-01 17:12:09 得分 0
没人会吗？加分问一下Top
2 楼peitsiang_gimi（雁南飞）回复于 2005-07-01 17:36:46 得分 0
select s.roomid, s.roomname, t.count(*) from roominfo t
left join room s on t.roomid=s.roomid group by s.roomid, s.roomnameTop
3 楼zklove（牧野星魂）回复于 2005-07-01 17:47:36 得分 0
select s.roomname,s.roomid,(select t.count(*) from roominfo where roominfo.roomid=s.roomid) as tmp from qq_room s left join roominfo on s.roomid=roominfo.roomidTop
4 楼chenylin（陈SIR）回复于 2005-07-01 17:47:42 得分 45
SELECT roomid, roomname,
(SELECT COUNT(*)
FROM roominfo
WHERE room.roomid = roominfo.roomid) AS RS
FROM roomTop
5 楼zklove（牧野星魂）回复于 2005-07-01 17:52:50 得分 5
如果想得到和ROOM表的ROOMID相对应的记录数,就用
select s.roomname,s.roomid,(select t.count(*) from roominfo where roominfo.roomid=s.roomid group roominfo.roomid) as tmp from qq_room sTop
6 楼merkey2002（小样的）回复于 2005-07-01 19:48:26 得分 0
你用 chenylin(陈SIR)的就可以了Top
7 楼lsp5i5j（星辰->女人在哪）回复于 2005-07-04 09:09:24 得分 0
chenylin(陈SIR) ( ) 接分，可以了Top
