select zdsm.numb_id, zdsm.product_name, zdsm.product_number,
jxssm.out_date, jxssm.shop_code as jx_shop_code, jxssm.shop_name as jx_shop_name, jxssm.shop_area_name as jx_shop_area,
zdsm.shop_name as zd_shop_name, zdsm.shop_code as zd_shop_code, zdsm.shop_area_name as zd_area, zdsm.sm_date

from (select gusl.numb_id, cast(gusl.created_at as date) as sm_date, gusl.product_name, gusl.product_number,
gs.code as shop_code, gs.name as shop_name, ga.name as shop_area_name, ga.code as shop_area_code
from gbc_user_sm_logs as gusl
left join gbc_shops as gs on gusl.shop_id=gs.id
left join gbc_ad_areas as gaa on gs.ad_code=gaa.ad_code
left join gbc_areas as ga on ga.id=gaa.area_id
where gusl.status in (0, 1)) as zdsm

left join
(select fi.num_id, cast(fi.u_time as date) as out_date, ckl.type, p.type as product_name, p.number as product_number,
ck.name as shop_name, ck.yw_number as shop_code, ga.name as shop_area_name, ga.code as shop_area_code
from fwcx_id as fi left join cangku as ck on ck.pinyin=fi.[to]
left join ck_list as ckl on substring(ckl.idnum, 4, 8)=convert(nvarchar(50), fi.num_id)
left join product as p on ckl.cp_type_id=p.id
left join gbc_areas as ga on ga.code=ck.number
where ckl.type=2) as jxssm

on substring(zdsm.numb_id, 4, 8)=convert(varchar(10), jxssm.num_id)
where zdsm.shop_area_code <> jxssm.shop_area_code