VbzCart/queries/qryOrdLines PkgdQtys

Details

 * Requires: ,
 * Used by: order detail in Item table
 * History:
 * 2008-11-21: Added CatNum, Descr, OrdNum, WhenStarted, ID_Pull fields

SQL
CREATE OR REPLACE VIEW qryOrdLines_PkgdQtys AS SELECT ol.ID, ol.ID_Order, o.Number AS OrdNum, o.WhenStarted AS OrdDate, o.ID_Pull, ol.ID_Item, ol.CatNum, ol.Descr, ol.QtyOrd, pl.QtyDone, pl.QtyShipped, pl.QtyExtra, pl.QtyNotAvail, pl.QtyKilled FROM (ord_lines AS ol   LEFT JOIN qryPkgLines_byOrdLine_andItem AS pl ON pl.ID_OrdLine=ol.ID) LEFT JOIN core_orders AS o ON ol.ID_Order=o.ID;