create view vcode_gude_order
as
select a.*,
b.area_name, b.zone_name, b.street_name, b.resid_name,
b.code, b.zone_code, b.street_code, b.resid_code
from (
select a1.*, b1.area_id from guide_order a1 inner join sys_user b1 on a1.post_user_id=b1.id
/*通过录入人id的area_id来获取code*/
) a
inner join report_sys_area b
on a.area_id=b.id
create view vcode_gude_order
as
select a.*,
b.area_name, b.zone_name, b.street_name, b.resid_name,
b.code as code1, b.zone_code, b.street_code, b.resid_code
from (
select a1.*, b1.area_id from guide_order a1 inner join sys_user b1 on a1.post_user_id=b1.id
/*通过录入人id的area_id来获取code*/
) a
inner join report_sys_area b
on a.area_id=b.id
create view vcode_gude_order
as
select a.*,
b.area_name, b.zone_name, b.street_name, b.resid_name,
b.code as b_code, b.zone_code, b.street_code, b.resid_code
from (
select a1.*, b1.area_id from guide_order a1 inner join sys_user b1 on a1.post_user_id=b1.id
/*通过录入人id的area_id来获取code*/
) a
inner join report_sys_area b
on a.area_id=b.id
