score:0

Accepted answer

This should give you what you are looking for.

    select distinct stock_yard_name, stock, sale
    from (
    select stock_yard_name , sum(stock_net_weight)  stock
    from table1 
    group by stock_yard_name) t1 
    join (
    select sale_yard_name,  sum( sale_net_weight) sale
    from  table2
      group by sale_yard_name
    ) t2 on stock_yard_name = sale_yard_name

score:-1

select ref.stock_yard_name,ref.stock_net_weight as stock, ref.sale_net_weight as sale,
ref.stock_net_weight - ref.sale_net_weight as advance
from(
select st.stock_yard_name as stock_yard_name, sum(st.stock_net_weight) stock_net_weight, sa.sale_net_weight
from tbl_stock st
inner join 
(
  select sale_yard_name, sum(sale_net_weight) sale_net_weight
  from tbl_sale
   group by sale_yard_name
 ) sa on (st.stock_yard_name = sa.sale_yard_name)
 group by st.stock_yard_name,sa.sale_net_weight
  )ref
order by ref.stock_yard_name asc

More Answer

More answer with same ag