VbzCart/queries/qryOrdLines PkgdQtys

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries
Revision as of 23:43, 3 December 2008 by Woozle (talk | contribs) (New page: ==Details== * '''Requires''': {{vbzcart/query|qryPkgLines_byOrdLine_andItem}}, {{vbzcart/table|core_orders}} * '''Used by''': order detail in Item table * '''History''': ** '''2008-11-21''...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Details

  • Requires:
  1. REDIRECT Template:l/vc/query,
  2. REDIRECT Template:l/vc/table
  • Used by: order detail in Item table
  • History:
    • 2008-11-21: Added CatNum, Descr, OrdNum, WhenStarted, ID_Pull fields

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>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/queries/qryOrdLines_PkgdQtys&oldid=10926"