"Sharon" <anonymous@discussions.microsoft.com> wrote in message
news:f8bb01c40cb5$e2e29310$a101280a@phx.gbl...
> Dear All,
> Could anyone please help me with this problem which
> regarding the record number.i need to display a records
> as the following:
> No ID MemName
> ----- -------- ----------------------------------
> 1. 12345 NOVAINA HALIMAH
> 2. 12346 EDYA PUTRA
> 3. 12347 RICA MANDASARI
> 4. 12348 PAULUS EFENDI
> 5. 12349 LELY CHANDRA
>
> My queries are like following :
> select m.memcode as ID,m.memname as MemberName
> from memreg m, mbr_statemoney o
> where m.memcode=o.mbr_id and m.membank='BCA' and
> o.t_money>=50000 and o.pv_month='2004.02'
> order by m.membank,m.membkbch,m.membankac,m.memcode
>
>
> what queries do i need to add on at the Queries Analyser
> in order for me to display the record number in a file
> like above?1.,2.,3.,4........
>
> please help....
> it urgent!
>
> thanks
>
> sharon

> My queries are like following :
> select m.memcode as ID,m.memname as MemberName
> from memreg m, mbr_statemoney o
> where m.memcode=o.mbr_id and m.membank='BCA' and
> o.t_money>=50000 and o.pv_month='2004.02'
> order by m.membank,m.membkbch,m.membankac,m.memcode