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