我要查找一个集合,单独执行select ''''||replace(Ztdoc,',',''',''')||'''' as urls from sl_hot_sport t where t.Htype='164' and t.id=46,这句会得到'201509/11/121.png','201509/11/add.png','',
如果将这个结果放到语句select e.title, e.fileurl from ss_feature_document e
where e.fileurl in ('201509/11/121.png','201509/11/add.png',''),里是能得到数据的,但是如果这两句结合后。如下
就得不到数据了,
select e.title, e.fileurl from ss_feature_document e
where e.fileurl in (select ''''||replace(Ztdoc,',',''',''')||'''' as urls from sl_hot_sport t where t.Htype='164' and t.id=46)
不过后来论坛中有人帮助这样写,就行了
select e.title, e.fileurl,t.ztitle from sl_hot_sport t left join ss_feature_document e on t.id=e.itemid
where instr((select ''''||replace(Ztdoc,',',''',''')||'''' as urls from sl_hot_sport t where t.Htype='164' and t.id=46) , e.fileurl ) > 0 ;