Re: how to write query

On Fri, 19 Aug 2005 13:04:04 +0530, Yoshitha wrote:

>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

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
--

(Remove _NO_ and _SPAM_ to get my e-mail address)
.