VbzCart/queries/qryCat Items Stock

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:23, 29 November 2009 by Woozle (talk | contribs) (underlying query renamed)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  1. REDIRECT Template:l/vc/query
  • Used by: qryItTypsDepts_grpItems
  • Notes: This may turn out to be inefficient, since it retrieves a lot of data which may not be needed
  • History:
    • 2009-04-12 Created to replace cat_items.qtyInStock field
    • 2009-11-29 Underlying query renamed

SQL

<mysql>CREATE OR REPLACE VIEW qryCat_Items_Stock AS SELECT 

 i.*,
 SUM(st.qtyForSale) AS qtyForSale,
 SUM(st.qtyForShip) AS qtyForShip

FROM (cat_items AS i LEFT JOIN qryStk_items_remaining AS st on i.ID=st.ID_Item) GROUP BY i.ID;</mysql>

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