create view web_order_view as
select web_kh.category as category,web_order.num as num,web_order.je as je,web_order.jsje as jsje,web_client.username as username,web_client.title as usertitle,web_client.zd1 as user_zd1 from web_order
left join web_client on web_client.id=web_order.uid
left join web_kh on web_kh.id=web_order.iid
where web_order.uid=web_client.id