Given the following data structure and relationship, is there a SQL statement that will allow me to extract a crosstab of the QTY field?
Table 1.
batchid
bincount
variety
Table 2.
batchid
descrip
qty
The tables are related on batchid.
The desired output format would have a column for each instance of a descrip while summing the qty for that descrip.
Thank you for any pointers.
Andrew
On a CLEAR day you can see forever.