VbzCart/queries/discarded/qryRstkReq wItem info

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | queries‎ | discarded
Revision as of 21:54, 2 March 2016 by Woozle (talk | contribs) (extracted from "discarded" page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Details

  • Status: not being used
  • History:
    • 2008-11-21 Created for new restock process
    • 2008-12-03 officially abandoned

SQL

<mysql>CREATE OR REPLACE VIEW qryRstkReq_wItem_info AS SELECT

 rqi.*,
 i.ID_Title,
 r.WhenCreated,
 r.WhenOrdered

FROM

 (rstk_req_item AS rqi
 LEFT JOIN cat_items AS i ON rqi.ID_Itme=i.ID)
 LEFT JOIN rstk_req AS rq ON rqi.ID_Restock=rq.ID;</mysql>