VbzCart/docs/queries/qryStk byItem byBin wInfo: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (+p.Descr) |
imported>Woozle (about: 2 tables also required) |
||
| Line 1: | Line 1: | ||
== | ==About== | ||
* '''Requires''': {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcart/query|qryCat_Items}} | * '''Requires''': {{vbzcart|table|stk_bins}}, {{vbzcart|table|stk_places}}, {{vbzcart/query|v_stk_byItemAndBin}}, {{vbzcart/query|qryCat_Items}} | ||
* '''Used by''': {{vbzcart/query|qryStock_forOpenOrders}} | * '''Used by''': {{vbzcart/query|qryStock_forOpenOrders}} | ||
* '''History''': | * '''History''': | ||
Revision as of 02:05, 25 April 2009
About
- Requires: Template:Vbzcart, Template:Vbzcart, Template:Vbzcart/query, Template:Vbzcart/query
- Used by: Template:Vbzcart/query
- History:
- 2009-02-07 Added p.Descr so "stock needed for orders" can show where bins are
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,
p.Descr AS PlcDescr
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
) LEFT JOIN stk_places AS p ON b.ID_Place=p.ID;</mysql>
<section end=sql />