VbzCart/docs/queries/v stk byItemAndBin wItemInfo

From Woozle Writes Code
< VbzCart‎ | docs‎ | queries
Revision as of 02:00, 4 December 2008 by imported>Woozle (New page: ==Details== * '''Status''': Is anything actually using this? '''Document!''' (I've tentatively removed the link in Access.) * '''Requires''': {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcar...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Details

SQL

<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wItemInfo AS

 SELECT * FROM v_stk_byItemAndBin AS s LEFT JOIN qryCat_Items AS i ON s.ID_Item=i.ID;</mysql>

<section end=sql />