VbzCart/queries/qryStk byItem byBin wInfo

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

About

  1. REDIRECT Template:l/vc/query, qryCat_Items
  • Used by: qryStock_forOpenOrders
  • History:
    • 2009-02-07 Added p.Descr so "stock needed for orders" can show where bins are
    • 2009-04-24 Added p.Name, which is what "stock needed for orders" should be showing
      • commenting out p.Descr->PlcDescr because it probably isn't needed
    • 2010-02-23 Renaming this from v_stk_byItemAndBin_wInfo to qryStk_byItem_byBin_wInfo
      • Also, v_stk_byItemAndBin was renamed to qryStk_byItem_byBin

SQL

<mysql>CREATE OR REPLACE VIEW qryStk_byItem_byBin_wInfo AS 

 SELECT
   s.*,
   i.*,
   b.ID_Place,
   b.Code AS BinCode,
   b.Descr AS BinDescr,
   p.Name AS PlcName

/* p.Descr AS PlcDescr */ 

 FROM
 ((
     qryStk_byItem_byBin AS s LEFT JOIN qryCat_Items AS i ON s.ID_Item=i.ID
   ) LEFT JOIN stk_bins AS b ON s.ID_Bin=b.ID
 ) LEFT JOIN stk_places AS p ON b.ID_Place=p.ID;</mysql>

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