I integrated the query you gave to me to my existing tables.
but at the following section I had a problem.
where t2.memberID=t1.memberID and t2.recID <= t1.recID
basicly I changed the "t2.recID <= t1.recID" section to "t2.islemtarihi <= t1.islemtarihi" which is the recording date and it works perfectly but on the records which has the same date it repeats the same number like:
to prevent the repeats, I need to keep the islemtarihi order, plus add a recID section. So basicly it will check the islemtarihi first in the order if the islemtarihi is same date, then it will use smaller recID.