JOIN

SELECT
IFNULL(SUM(ol.list_price),0) list_price,
IFNULL(SUM(ol.sell_price),0) sell_price,
IFNULL(SUM(ol.buy_price),0) buy_price,
IFNULL(SUM(ol.order_count),0) order_count,
ob.*
FROM orderbook AS ob LEFT OUTER JOIN orderbooklist AS ol ON ob.order_no=ol.order_no
WHERE buyer_name LIKE ‘%7%’ OR ob.order_no = ‘7’