TBL_Handlelog快速查询

查询单位

• tbl_handlelog

select * from tbl_handlelog where keyid in (select hiscompanycode from tbl_inv_company ) and buscode ='COMPANYADD' 
and status = 0

• tbl_errorlog

查询套餐

• tbl_handlelog

select * from tbl_handlelog where keyid in (select hisgroupcode from tbl_inv_meal ) and buscode ='MEALCHANGE' 
and status = 0

select * from tbl_handlelog where keyid in (select to_char(rwfzid) from HM_YW_TTRWFZ where rwid00 ='1202' ) and buscode ='MEALCHANGE' 
and status = 0

• tbl_errorlog

select *  from tbl_errorlog where relatedid in (
select to_char(rwfzid) from HM_YW_TTRWFZ where rwid00 ='1202'
)

查询订单

• tbl_handlelog

• tbl_errorlog

  select *  from tbl_errorlog where relatedid in (
  select hisexamineenum from tbl_inv_group_person where upload = 0 and hiscompanycode ='1742' )