51问答网 > oracle的多条件多表查询：求解，查询符合条件的两张表中两个字段的记录

oracle的多条件多表查询：求解，查询符合条件的两张表中两个字段的记录

2025-03-16 22:32:05

推荐回答（3个）

回答1：

select a.a_food,b.b_name
from a,b where a.b_id=b.id and b.b_name like '%肉%'

回答2：

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的记录查出来。

回答3：

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 '%肉%')