简单的创建视图语句

create view tp5_sub_order_view as
select
sub.id as id,
sub.oid as oid,
sub.count as count,
sub.price as price,
p.name as name,
p.img_sm_url as img_sm_url
from
(
tp5_sub_order sub left join tp5_products p on (( sub.pid = p.id ))
);