"Yoshitha" <gudivada_***@rediffmail.com> wrote in message
news:%23s6zz%23IpFHA.3828@TK2MSFTNGP12.phx.gbl...
>I have a table with the fileds  empid,empname,designation,branch.. etc I
> have 5 types of  designations CEO,BM,PL,Tester,and PRG and the two
> branches
> those are Hyderabad and Visakhapatnam i need the query like
> first CEO name next Hyderabad BM Name next Hyderabad PL name next
> Hyderabad
> Testername next Hyderabad Prg Names next Visakhapatnam BM name next
> visakhapatnam PL name next Visakhapatnam TesterNames and Visakhapatnam Prg
> Names......
>
>
>
> Please help...me
>
>
>
> Regards,
> Krishna Murthy.K
>
>