select * from Td_Oss_Action

select * from td_oss_product

select * from td_so_template where prod_id ='1433';

select * from

select t.al 总数, p.prod_name 产品, a.action_name 动作,t.prod_id,t.CHG_SERV_SPEC_ID
  from (select count(*) al, prod_id, CHG_SERV_SPEC_ID
          from tf_so
         group by prod_id, CHG_SERV_SPEC_ID
        having prod_id in(1433,
                         1434,
                         958825,
                         958826,
                         1412,
                         1413,
                         1419,
                         1420,
                         1403,
                         1409,
                         1431,
                         1432,
                         1435,
                         1436)) t
  left join td_oss_product p
    on t.prod_id = p.prod_id
  left join td_oss_action a
    on t.chg_serv_spec_id = a.action_id

SELECT S.TEAM ||'**'|| S.NAME ||'**'|| S.JOB_NUMBER   

FROM STAFF S WHERE S.PASS ='123456' AND S.TEAM ='南方'