VbzCart/queries/qryRpt Pkg Lines
Jump to navigation
Jump to search
About
- Requires: ord_pkg_lines, ord_lines,
- REDIRECT Template:l/vc/query
- History:
- 2011-05-31 ported from MS Access so I can print packing slips from web interface (final major piece?)
SQL
<mysql>CREATE OR REPLACE VIEW qryRpt_Pkg_Lines AS SELECT
p.ID AS ID, p.ID_Pkg, o.Seq, IFNULL(o.CatNum,i.CatNum) AS CatNum, IFNULL(o.Descr,i.Descr) AS Descr, o.QtyOrd, p.QtyShipped, p.QtyExtra, p.QtyNotAvail, p.QtyKilled, o.Price, o.ShipItm, o.ShipPkg, i.ID_Title
FROM (
ord_pkg_lines AS p LEFT JOIN ord_lines AS o ON p.ID_OrdLine=o.ID) LEFT JOIN qryCat_Items AS i ON p.ID_Item=i.ID;</mysql>