Displaying columns from 2 independant tables

From: Wes (wharrison_at_adcbarcode.com)
Date: 12/10/04

  • Next message: Hugo Kornelis: "Re: Displaying columns from 2 independant tables" 
    Date: Fri, 10 Dec 2004 09:55:41 -0800

    I have a table as follows:

    Code Quantity Status
    ACC1 50 Dispatched
    ACC2 31 Dispatched
    ACC3 62 Dispatched
    ACC4 11 Awaiting Dispatch
    ACC5 13 Dispatched
    ACC5 5 Awaiting Dispatch
    ACC6 21 Awaiting Dispatch

    I would like to sum the quantity of each code and staus
    and display in tabular format as follows

    Code Qty Dispatched Qty Awaiting Dispatch
    ACC1 50 0
    ACC2 31 0
    ACC3 62 0
    ACC4 0 11
    ACC5 13 5
    ACC6 0 21

    Is this possible?

    Thanks Wes

  • Next message: Hugo Kornelis: "Re: Displaying columns from 2 independant tables"