like后面如何用select语句

(1)select * from tab_xn_company t where t.company_name like '%'||(select c.company_name from tab_xn_company c where c.company_id='1179')||'%';

 

 

(2)select * from r_user t where t.description like (select '%'||tt.supplier_name||'%' from crm_supplier_baseinfo tt where tt.supplier_id = '94581');

 

(3)select * from A, B where A.id = B.id and A.name like '%'||B.name||'%'

 

select A.region_id,A.region_code,B.region_code from tbregion A,tbregion B
 where A.region_id=_____  and B.region_id=____
and A.region_code like '%'||B.region_code||'%'