select a.a_food,b.b_name
from a,b where a.b_id=b.id and b.b_name like '%肉%'
select a.b_id,a.a_food,b.b_name from a inner join b on a.b_id = b.id where (a.a_food like '%肉%') and (b.b_name like '%肉%')
这样可以把量表中同时具有id的记录查出来。
select a.b_id,a.a_food,b.b_name from a,b where a.b_id=b.id and a.b_id,a.a_food,b.b_name not in (select c.b_id,c.a_food,d.b_name from a c,b d where c.b_id=d.id and c.a_food not like '%肉
%' and d.b_name not like '%肉%')
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024