17,086
社区成员
发帖
与我相关
我的任务
分享
select * from t_mer_info tmi where tmi.bms_apply_type = '0' and tmi.profit_status ='5'
select t.mer_no,
t.mer_name,
t.mer_address,
t.mer_contactor,
t.mer_mobile,
t.mer_tel,
t.mer_email,
t.mer_source,
t.profit_status,
t.bms_apply_type,
t.bms_mer_no,
hx.inst_no,
hx.supinstno,
hx.inst_name,
to_char(mp.CREATE_TIME, 'yyyy-MM-dd HH24:mi:ss') as create_time,
pa.ACCOUNT_NO,
pa.ACCOUNT_NAME
from t_mer_info t
inner join account.t_inst hx
on t.org_no = hx.inst_no
inner join t_mer_profitact mp
on t.id = mp.mer_id
inner join T_PROFIT_ACCOUNT pa
on mp.id = pa.PROFITACT_ID
where pa.DEFAULT_ACCOUNT = '1'
and t.bms_apply_type = '0'
and t.profit_status ='5'