Edit Report:Price Test 2
Menu Anchors
'customers', 'orders', 'sales', 'payables', 'warehouse', 'dispatching', 'receivables', 'payables-dash', 'inventory', 'purchases', 'generallendger', 'users',-- Price Test 2
-- QITMEXP
-- No Drill Downs
SELECT
s.stockid as `Item No`,
s.description as `Item Description`,
(SELECT CASE WHEN (p.typeabbrev = 'A' THEN p.price ELSE 0) END AS List FROM prices p INNER JOIN stockmaster s on s.stockid = p.stockid)
FROM
stockmaster s