17,082
社区成员
发帖
与我相关
我的任务
分享
create or replace view v_baseobject as
select .……(CASE WHEN A.SSSSOBJECTNAME LIKE '^1%' THEN jm_decryption(A.SSSSOBJECTNAME) ELSE A.SSSSOBJECTNAME END) as ssssobjectnam…………
from countydata.BASEOBJECT a Left Join countydata.BASEOBJECTACCOUNT b on a.OBJECTID = b.OBJECTID inner Join countydata.OBJECTGH d on a.OBJECTID = d.ID;