不是太清除你想达到一个什么样的效果,如果是查询a中b_id1和b_id2与b表中id相等的记录可以用下面的方法select a.* ,b.name as name2,b.anme as name1
from a join b on b.id=a.b_id1 join b on b.id=a.b_id2
换成
select a.* ,b.name as name2,b.anme as name1
from a inner join b on b.id=a.b_id1 and b.id=a.b_id2
from a join b on b.id=a.b_id1 join b on b.id=a.b_id2
换成
select a.* ,b.name as name2,b.anme as name1
from a inner join b on b.id=a.b_id1 and b.id=a.b_id2
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货