VbzCart/queries/qryStk History

About

 * Purpose: plus  data, if any, with IDs adjusted to prevent duplicates. Lets you see the complete history including legacy stuff, without polluting the main log with non-fixable legacy data.
 * History:
 * 2008-12-29 Created
 * 2008-12-30 Added "ORDER BY ID" so everything will be in sequence (apparently ORDER BY is assumed to refer to the whole UNION, and can't be used within the individual SELECTs that go into the UNION)

SQL
CREATE OR REPLACE VIEW qryStk_History AS SELECT * FROM stk_history UNION SELECT CAST(ID-5000 AS SIGNED) AS ID, ID_StkBin, ID_StkLine, CH_OthType, ID_OthCont, ID_OthLine, IDS_OthCont, ID_Item, QtyBefore, QtyAdded, QtyAfter, QtyBinBefore, QtyBinAfter, `When`, What, Notes FROM stk_history_legacy ORDER BY ID;