finditem.sql

this is sample for traders

SELECT ITEM.ITEMCODE,ITEM.ITEMNAME,
IFNULL((SELECT ITEM_QTY.ONHAND FROM ITEM_QTY WHERE ITEMCODE=ITEM.ITEMCODE),0)  AS ONHAND,
ITEM.UNITID
FROM item
Order By ITEM.ITEMCODE