select iuser.userid, iuser.username from iuser join ibuddy on iuser.userid=ibuddy.userid where ibuddy.buddyid=5310
select iuser.userid, iuser.username from iuser where userid in (select userid from ibuddy where buddyid=5310)
就是把两个表中相同字段值的过滤出来。
select iuser.userid, iuser.username from iuser where userid in (select userid from ibuddy where buddyid=5310)
就是把两个表中相同字段值的过滤出来。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货