17,086
社区成员
发帖
与我相关
我的任务
分享
select a.V_ZBMCHENG,
a.V_ZBBMING,
a.V_EMGJSGSHI,
Lower(a.V_ZBBHAO) V_ZBBHAO,
a.V_ZBBHAO V_ZBBHAO_NEW,
Lower(a.V_JSGSHI) V_JSGSHI,
a.V_SFZYZB,
a.V_SFHGL,
a.HY_XMGLID,
a.HY_SCZBGL_ID,
a.V_XSDWSHU,
'' L_CSZHI,
'' HY_SCZB_DATA_ID
from hy_sczbgl a
left join (select *
from HY_SCZB_DATA
where hy_xmgliid = '4ecd77b7-9cfc-48d9-949d-9691d58962eb'
AND v_operator = 'jxstar'
AND v_lrsj = ''
AND v_time = ''
AND v_bcbh = '') b
on a.HY_SCZBGL_ID = b.HY_SCZBGLI_ID
where a.HY_XMGLID = '4ecd77b7-9cfc-48d9-949d-9691d58962eb'
select a.V_ZBMCHENG,
a.V_ZBBMING,
a.V_EMGJSGSHI,
Lower(a.V_ZBBHAO) V_ZBBHAO,
a.V_ZBBHAO V_ZBBHAO_NEW,
Lower(a.V_JSGSHI) V_JSGSHI,
a.V_SFZYZB,
a.V_SFHGL,
a.HY_XMGLID,
a.HY_SCZBGL_ID,
a.V_XSDWSHU,
b.N_VALUE L_CSZHI,
'' HY_SCZB_DATA_ID
from hy_sczbgl a
left join (select *
from HY_SCZB_DATA b
where b.hy_xmgliid = '4ecd77b7-9cfc-48d9-949d-9691d58962eb'
AND b.v_operator = 'jxstar'
AND b.v_lrsj = '2016-12-30'
AND b.v_time = '11:30'
AND b.v_bcbh = '早') b
on a.HY_SCZBGL_ID = b.HY_SCZBGLI_ID
where a.HY_XMGLID = '4ecd77b7-9cfc-48d9-949d-9691d58962eb'
select *
from HY_SCZB_DATA
where hy_xmgliid = '4ecd77b7-9cfc-48d9-949d-9691d58962eb'
AND v_operator = 'jxstar'
AND v_lrsj = ''
AND v_time = ''
AND v_bcbh = ''
select *
from HY_SCZB_DATA b
where b.hy_xmgliid = '4ecd77b7-9cfc-48d9-949d-9691d58962eb'
AND b.v_operator = 'jxstar'
AND b.v_lrsj = '2016-12-30'
AND b.v_time = '11:30'
AND b.v_bcbh = '早'