VbzCart/queries/qryRstkReq by status

About

 * Purpose: One of two queries which are UNIONed to create
 * Requires: ,
 * History:
 * 2008-12-22 Adapted from the discarded query qryCbxRestock_by_status

SQL
CREATE OR REPLACE VIEW qryRstkReq_by_status AS SELECT r.ID, CAST(   CONCAT( CAST(COALESCE( CONCAT('X ',DATE_FORMAT(r.WhenKilled,'%Y-%m-%d')), CONCAT('O ',DATE_FORMAT(r.WhenOrdered,'%Y-%m-%d')), CONCAT('C ',DATE_FORMAT(r.WhenCreated,'%Y-%m-%d')) ) AS BINARY), ' ',     s.CatKey, IFNULL(CONCAT(' [',r.PurchOrdNum,']'),'') ) AS CHAR ) AS Descr, NOT IsLocked AS IsOpen, r.WhenOrdered, r.WhenConfirmed, r.ID_Supplier FROM rstk_req AS r LEFT JOIN cat_supp AS s ON r.ID_Supplier=s.ID ORDER BY COALESCE(r.WhenKilled,r.WhenOrdered,r.WhenCreated) DESC;