On Wednesday 12 May 2004 11:02 am, Gary Stainburn wrote:
> Hi folks.
>
[snip]
> create view order_summary as
> select
> c.cs_id, cs.count as qty, c.cs_make, c.cs_code, c.cs_type,
> cst.cst_desc, c.cs_colour,
> o.or_id,
> o.or_supp, o.or_date, o.or_received, o.or_no, orst.orst_de
Hi folks.
I've got a database for my consumable stock. I have a consumables table
containing the type details, e.g. HP 4100 toner.
I then have a cons_stock table holding item details, one record per item (2
toners = 2 rows).
I have a order_dets view which pulls in all the data required inclu
