VbzCart/queries/qryStk Bins w info

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:58, 29 April 2009 by Woozle (talk | contribs) (+PlaceName)

About

  • Returns: stk_bins with additional information
  • Requires: stk_bins, qryStk_lines_remaining_byBin
  • Used by: Special:VbzAdmin's stock bin listing page
  • History:
    • 2009-04-29 Created for Special:VbzAdmin

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW qryStk_Bins_w_info AS 

 SELECT
   sb.*,
   sp.Name AS PlaceName,
   sq.QtyForSale,
   sq.QtyForShip,
   sq.QtyExisting
 FROM stk_bins AS sb
   LEFT JOIN qryStk_lines_remaining_byBin AS sq

ON sb.ID=sq.ID_Bin 

   LEFT JOIN stk_places as sp

ON sb.ID_Place=sp.ID;</mysql> <section end=sql />

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