SQL

 

select distinct b.web_doc_id,c.doc_name
  from sup_gts_user_setting  a,
       sup_gts_unite_info    b,
       sup_kc_doc_basic_info c
 where a.user_id = 'l00166121'
   and a.prop_type = '1'
   and ((b.class1_pbi_id = a.prop_id) or
       (b.CLASS1_PBI_ID || '/' || b.CLASS2_PBI_ID = a.prop_id) or
       (b.CLASS1_PBI_ID || '/' || b.CLASS2_PBI_ID || '/' ||
       b.CLASS3_PBI_ID = a.prop_id))    
   and b.web_doc_id = c.web_doc_id
   and b.lang_type = 'zh'
   and c.language_type='zh'

select  b.class1_pbi_name_cn,b.class2_pbi_name_cn,b.class1_pbi_id,b.class2_pbi_id,b.web_doc_id,c.doc_name
  from sup_gts_user_setting a, sup_gts_unite_info b,sup_kc_doc_basic_info c
 where a.user_id = 'l00166121'
   and a.prop_type = '1'
   and ((b.class1_pbi_id = a.prop_id) or
       (b.CLASS1_PBI_ID || '/' || b.CLASS2_PBI_ID = a.prop_id) or
       (b.CLASS1_PBI_ID || '/' || b.CLASS2_PBI_ID || '/' ||
       b.CLASS3_PBI_ID = a.prop_id))
       and b.class1_pbi_id='7275738' and b.class2_pbi_id='7275792'
       and b.web_doc_id =c.web_doc_id
       and c.web_doc_id in('SC0000506636' , 'SW0000263336')