5 lines
361 B
SQL
5 lines
361 B
SQL
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 |