RE: how to write query

Wow. Complicated.

Perhaps you could split your query into smaller queries?

To get this to do what you want try searching on-line for 'SELECT' and
'GROUP BY'. You might find some examples that will guide you toward what
you want.

Sorry I wasn't much help. Good luck!
--------------------
| From: "Yoshitha" <gudivada_kmm@xxxxxxxxxxxxxx>
| Subject: how to write query
| Date: Fri, 19 Aug 2005 13:04:18 +0530
| Lines: 18
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
| Message-ID: <OGJgu#IpFHA.3828@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.odbc
| NNTP-Posting-Host: 59.145.128.68
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.odbc:2598
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| 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
|
|
|

.