+ $sql = "SELECT inv.*, grn.*, unit_price AS FullUnitPrice,
+ stock.units,
+ tax_type.exempt,
+ tax_type.name as tax_type_name
+ FROM "
+ .TB_PREF."supp_invoice_items inv LEFT JOIN ".TB_PREF."grn_items grn ON grn.id =inv.grn_item_id
+ LEFT JOIN ".TB_PREF."stock_master stock ON stock.stock_id=inv.stock_id
+ LEFT JOIN ".TB_PREF."item_tax_types tax_type ON stock.tax_type_id=tax_type.id