create view

create view view_shipping as
SELECT   ssp.*,c.id_province, c.name city,p.name province, ss.service_name service,sc.name company
FROM
 `shipping_service_price4` ssp, city3 c, province p, shipping_service ss,shipping_company sc
WHERE
c.id_province=p.id_province
and ssp.id_city=c.id_city
and ss.id_service=ssp.id_service
and ss.id_company=sc.id_company;

CREATE VIEW view_city AS select
c.id_city,c.id_province, c.name city,p.name province
 from city c, province p
where c.id_province=p.id_province;

CREATE VIEW view_sales AS select
SELECT
s.* ,b.name bank, c.name customer, c.birthday ultah, c.telp, c.hp,c2.name city,p.name province,c.email
FROM `sales` s, customer c, city c2, province p, bank b
WHERE
c.code=s.customer_code
and c.id_city=c2.id_city
and c.id_province=p.id_province
and b.code=s.pay_to