Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    boise
    Posts
    1

    Question Unanswered: need help with create view

    Any help is greatly appreciated. I can't seem to create a view for my select statement, When I run the select by itself it returns over 100 rows of results, but as soon as I add Create View (name) As no results. Thanks for the help - Jeanette

    Create View order_lookup
    As
    Select c.company_name,c.address,c.city,c.postal_code,c.co untry,
    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,o h.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);

  2. #2
    Join Date
    Feb 2004
    Location
    Siggenthal, Switzerland
    Posts
    19
    Hello

    Did you try creating a view with a simple query?
    Does only this view don't work and the other works
    on your database?

    Walter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •