使用B表中的多结果字段作为查询条件,模糊查询A表中的数据
示例:SELECT A.*
FROM TABLE_NAME_A A,
(SELECT C_PLAN_CDE
FROM TABLE_NAME_B
WHERE C_DPT_CDE LIKE ('%72%')) B
WHERE A.C_PLAN_CDE LIKE '%' || B.C_PLAN_CDE || '%';
使用B表中的多结果字段作为查询条件,模糊查询A表中的数据
示例:SELECT A.*
FROM TABLE_NAME_A A,
(SELECT C_PLAN_CDE
FROM TABLE_NAME_B
WHERE C_DPT_CDE LIKE ('%72%')) B
WHERE A.C_PLAN_CDE LIKE '%' || B.C_PLAN_CDE || '%';