SELECT opname,SUM(bookprice)
FROM TABLE1 ,TABLE2 ,TABLE3
WHERE table2.bookno=table1.bookno
table2.opno=table3.opno
GROUP BY opname
FROM TABLE1 ,TABLE2 ,TABLE3
WHERE table2.bookno=table1.bookno
table2.opno=table3.opno
GROUP BY opname
FROM TABLE2 ,TABLE3
WHERE table2.opno=table3.opno
GROUP BY opname
FROM TABLE2 left join TABLE3
on table2.opno=table3.opno
GROUP BY opname