--第一种
select C.AID,A.NAME,C.BID,B.NAME from C
join A on A.ID=C.AID and A.name like '%%'
join B on B.ID=C.BID and B.name like '%%'
--第二种
select C.AID,A.NAME,C.BID,B.NAME from C
join A on A.ID=C.AID 
join B on B.ID=C.BID 
where A.name like '%%'
and B.name like '%%'

------解决方案--------------------
貌似是最基础的连接查询  参考LS

------解决方案--------------------
也许用exists效率稍高

------解决方案--------------------
探讨

SQL code


--第一种
select C.AID,A.NAME,C.BID,B.NAME from C
join A on A.ID=C.AID and A.name like '%%'
join B on B.ID=C.BID and B.name like '%%'
--第二种
select C.AID,A.NAME,C.BID,B.NAME from C
join……