Re: Oracle and PICK

From: Nick <nquinnusa_at_earthlink.net>
Date: Sat, 17 Apr 2004 11:34:15 GMT
Message-ID: <XC8gc.12319$zj3.10639@newsread3.news.atl.earthlink.net>

Ok,

Define an Order Header and the Order Items in that table, please.

I.E. The deader has

Number
Customer
Customer address
Customer Phone
Order date
Total Order Cost

The Items have

      Item number
      Product Number
      Product Price

There may be more than one 'item' for any order...

"Tony" <andrewst_at_onetel.net.uk> wrote in message news:c0e3f26e.0404170059.19bcf3d1_at_posting.google.com...
> "Nick" <nquinnusa_at_earthlink.net> wrote in message
news:<as0gc.9193$l75.5272_at_newsread2.news.atl.earthlink.net>...
> > Schema for the table please?
>
> Please explain what you mean - I already gave you a CREATE TABLE
> statement. What more do you need?
Received on Sat Apr 17 2004 - 06:34:15 CDT