VbzCart/docs/queries/qryStk byItem byBin wInfo: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==Details== * '''Requires''': {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcart/query|qryCat_Items}} * '''Used by''': ==SQL== <section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItem...) |
imported>Woozle (used by qryStock_forOpenOrders) |
||
| Line 1: | Line 1: | ||
==Details== | ==Details== | ||
* '''Requires''': {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcart/query|qryCat_Items}} | * '''Requires''': {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcart/query|qryCat_Items}} | ||
* '''Used by''': | * '''Used by''': {{vbzcart/query|qryStock_forOpenOrders}} | ||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS | <section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS | ||
Revision as of 00:59, 8 February 2009
Details
- Requires: Template:Vbzcart/query, Template:Vbzcart/query
- Used by: Template:Vbzcart/query
SQL
<section begin=sql /><mysql>CREATE OR REPLACE VIEW v_stk_byItemAndBin_wInfo AS
SELECT s.*, i.*, b.ID_Place, b.Code AS BinCode, b.Descr AS BinDescr FROM ( v_stk_byItemAndBin AS s LEFT JOIN qryCat_Items AS i ON s.ID_Item=i.ID ) LEFT JOIN stk_bins AS b ON s.ID_Bin=b.ID;</mysql>
<section end=sql />