>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.nCount >>