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_at_newsread3.news.atl.earthlink.net>
Date: Sat, 17 Apr 2004 11:34:15 GMT
Message-ID: <XC8gc.12319$zj3.10639_at_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 - 13:34:15 CEST