SQL QUERY WITH HAVING CLAUSE SELECTING FROM MULTIPLE TABLES : [this is the tried syntax[\]\[1\]][1]

select cc, sum(a.hours),b.labcost from labour a,othshop b where lab_cd='hs' and a.mon=03 and a.yr=2010 group by a.cc HAVING a.cc=b.occ AND b.mon=03 and b.yr=2010;

I HAVE ALL THE TABLES WELL DEFINED STILL MY SQL SYNTAX IS NOT WORKING. IF ANY GUY CAN SOLVE THIS I WILL BE HIGHLY BENIFITED.
  [1]: https://i.stack.imgur.com/uTcx6.jpg