VbzCart/queries/qryStk Bins w info

About

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

SQL
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;