VbzCart/docs/queries/qryOrdLines PkgdQtys: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Jump to navigation Jump to search
imported>Woozle
(New page: ==Details== * '''Requires''': {{vbzcart/query|qryPkgLines_byOrdLine_andItem}}, {{vbzcart/table|core_orders}} * '''Used by''': order detail in Item table * '''History''': ** '''2008-11-21''...)
 
m (Woozle moved page VbzCart/VbzCart/queries/qryOrdLines PkgdQtys to VbzCart/docs/queries/qryOrdLines PkgdQtys without leaving a redirect: part 2)
 
(No difference)

Latest revision as of 01:55, 25 February 2024

Details

SQL

<section begin=sql /><mysql>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;</mysql>

<section end=sql />

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/qryOrdLines_PkgdQtys&oldid=6777"