SELECT Patient_treatments.memcode, Patient_treatments.iid,; Patient_treatments.itreatid, Patient_treatments.ddatetime,; Patient_treatments.nqty, Patient_treatments.yprice,; Patient_treatments.ncount, Treatments.ccode, Treatments.cdesc,; SUM( Consultancydetails.iqty) AS nUsed; FROM physician!treatments INNER JOIN physician!patient_treatments; INNER JOIN physician!consultancydetails; INNER JOIN membership!member; RIGHT OUTER JOIN physician!consultancydetails ; ON Consultancydetails.itreatid = Patient_treatments.iid ; ON Patient_treatments.memcode = Member.card_no ; ON Treatments.iid = Consultancydetails.itreatid ; ON Treatments.iid = Patient_treatments.itreatid; WHERE Member.card_no = ?vp_memcode; GROUP BY Patient_treatments.iid, Patient_treatments.memcode,; Patient_treatments.itreatid, Patient_treatments.ddatetime,; Patient_treatments.nqty, Patient_treatments.yprice,; Patient_treatments.ncount HAVING nUsed < Patient_Treatments.nCountPlease advise