Difference between revisions of "VbzCart/queries/discarded"
Jump to navigation
Jump to search
(v_items) |
(qryRstkReq_wItem_info) |
||
| Line 29: | Line 29: | ||
((`i`.`ID_ItOpt` = `io`.`ID`)));</mysql> | ((`i`.`ID_ItOpt` = `io`.`ID`)));</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
| + | ==qryRstkReq_wItem_info== | ||
| + | ===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> | ||
Revision as of 23:54, 3 December 2008
v_items
Details
- Used by: clsItemsExt (MS Access) -- as of 2008-11-30, this class does not seem to be in use anymore. It probably was not included in the big rescue operation when the old order DB developed some unopenable modules.
SQL
<mysql>CREATE OR REPLACE VIEW `v_items` AS
SELECT
i.ID,
i.CatNum,
i.isForSale,
i.isMaster,
i.qtyInStock,
i.isInPrint,
i.isCloseOut,
i.isPulled,
i.isDumped,
i.ID_Title,
i.ID_ItTyp,
i.ID_ItOpt,
i.ItOpt_Descr,
i.ID_ShipCost,
i.PriceBuy,
i.PriceSell,
i.PriceList,
i.Supp_CatNum,
io.Sort AS OptSort
FROM (
`cat_items` AS `i` LEFT JOIN
`cat_ioptns` AS `io` ON
((`i`.`ID_ItOpt` = `io`.`ID`)));</mysql>
qryRstkReq_wItem_info
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>