SELECT t1.typeid,t1.name,t2.state,t2.name
FROM (SELECT a.typeid,b.name FROM A a,B b WHERE a.typeid = b.keyvalue AND b.id ='typeid') t1,
(SELECT a.state,b.name FROM A a,B b WHERE a.state = b.keyvalue AND b.id = 'state') t2
WHERE t1.typeid = t2.state;
你参考下这个是多对多查询 语句
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024