select vendTrans group by AccountNum join vendTrans2 where vendTrans.AccountNum == vendTrans2.AccountNum && vendTrans.RecId != vendTrans2.RecId;