I appreciate any help. My select statement returns over 100 rows, but as soon as I add Create View (name) As nothing is returned. Can anyone tell me what I'm doing wrong :rolleyes:
Create View order_lookup
As
Select c.company_name,c.address,c.city,c.postal_code,c.country,
e.last_name,e.first_name,
p.product_name,
od.unit_price,od.quantity,od.discount_pct,
oh.order_date, oh.required_date, oh.shipped_date,oh.ship_to, oh.ship_address,oh.ship_city,oh.ship_postal_code,oh.ship_country,
sh.company_name
From customer c
Join order_header oh On (c.customer_id = oh.customer_id)
Join order_detail od On (oh.order_id = od.order_id)
Join product p On (od.product_id = p.product_id)
Join employee e On (e.employee_id = oh.employee_id)
Join shipper sh On (sh.shipper_id = oh.ship_via);
