VbzCart/docs/queries/discarded/qryRstkReq wItem info

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries‎ | discarded
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>
Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/queries/discarded/qryRstkReq_wItem_info&oldid=6730"