VbzCart/queries/qryStk byItem byBin wInfo

About

 * Requires:, , ,
 * Used by:
 * 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
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;