VbzCart/queries/qryRpt Pkg Lines: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
copied, not tested |
returns data now; accuracy not tested |
||
| Line 9: | Line 9: | ||
p.ID_Pkg, | p.ID_Pkg, | ||
o.Seq, | o.Seq, | ||
IFNULL(o.CatNum,i.CatNum) AS CatNum, | |||
IFNULL(o.Descr,i.Descr) AS Descr, | |||
o.QtyOrd, | o.QtyOrd, | ||
p.QtyShipped, | p.QtyShipped, | ||
| Line 25: | Line 25: | ||
qryCat_Items AS i ON p.ID_Item=i.ID;</mysql> | qryCat_Items AS i ON p.ID_Item=i.ID;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 16:43, 31 May 2011
About
- Requires: ord_pkg_lines, ord_lines, qryCat_Items
- History:
- 2011-05-31 ported from MS Access so I can print packing slips from web interface (final major piece?)
SQL
<section begin=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>
<section end=sql />
