item_vs_saldo.sql

this is sample for traders

SELECT item.*, IFNULL((SELECT onhand from item_qty where item.itemcode=itemcode),0) as onhand
FROM item