- $sql = "SELECT ".TB_PREF."purch_orders.*, "
- .TB_PREF."suppliers.*, "
- .TB_PREF."locations.location_name
- FROM ".TB_PREF."purch_orders, ".TB_PREF."suppliers, ".TB_PREF."locations
- WHERE ".TB_PREF."purch_orders.supplier_id = ".TB_PREF."suppliers.supplier_id
- AND ".TB_PREF."locations.loc_code = into_stock_location
- AND ".TB_PREF."purch_orders.order_no = ".db_escape($order_no);
+ $sql = "SELECT po.*, tg.tax_area, supplier.*, loc.location_name
+ FROM ".TB_PREF."purch_orders po,"
+ .TB_PREF."suppliers supplier
+ LEFT JOIN ".TB_PREF."tax_groups tg ON supplier.tax_group_id=tg.id,"
+ .TB_PREF."locations loc
+ WHERE po.supplier_id = supplier.supplier_id
+ AND loc.loc_code = into_stock_location
+ AND po.order_no = ".db_escape($order_no);