select max(cClient_Account_Number) as cClient_Account_Number, ; min(TR.cTrans_Relateds_Pk) as cTrans_Relateds_Pk, ; count(*) as cntGuarantors from Trans inner join Trans_Relateds TR on ; Trans.cTrans_pk = TR.cTrans_fk ; where TR.iGuarantor_flag = 1 and TR.iPrimary_flag = 0 ; group by Trans.cTrans_pk having cntGuarantors = 1 ; into cursor curProblemsCan you tell me, if I'm wrong and how should I re-write this SQL?