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

[quoted text, click to view]

Hi Krishna,

I would, if I understood what exactly you want.

Narrative is often not the best way to describe a problem. Especially if
neither the one describing, nor the one trying to understand, has
English as native language. :-)

A much better way to describe a problem in these group is to post:
* CREATE TABLE statements to describe exactly how your tables look. If
there are many irrelevant columns, just omit them. But do include all
constraints and properies for remaining columns!
* INSERT statements to load the tables with a few chosen rows of sample
data that accurately describe your problem.
* Expected output.
* And a short description of the business problem you're trying to
solve.

Check out www.aspfaq.com/5006 - it has some useful tools that might help
you assemble the information needed faster.

Best, Hugo
--