VbzCart/queries/discarded/qryRstkReq wItem info
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>