Query needed

Hi All,
I have a table
Task(
idTask int primary key,
sTask varchar(60)
)
with the following data.
idTask sName
--
1 B
2 A
3 C
4 B
5 D
6 E
7 B
8 D
Now i want a query which return the data in the following format
2 A
1,4,7 B
3 C
5,8 D
TIA
Satyahttp://support.microsoft.com/newsgr...n-us&sloc=en-us
AMB
"Satya" wrote:

> Hi All,
> I have a table
> Task(
> idTask int primary key,
> sTask varchar(60)
> )
> with the following data.
> idTask sName
> --
> 1 B
> 2 A
> 3 C
> 4 B
> 5 D
> 6 E
> 7 B
> 8 D
> Now i want a query which return the data in the following format
> 2 A
> 1,4,7 B
> 3 C
> 5,8 D
> TIA
> Satya
>|||This is called violationof First Normal Form and good SQL programmers
do not do it. Display is handled in the front end in a tiered
architecture. This is more fundamental than just SQL, so you might
want to take a class in software engineering.|||No sql coding necessary with the RAC utility for S2k.
See the @.concatenate operator in the Help file.
RAC and QALite @.
www.rac4sql.net|||Yes this is not relational approach.
It should be handled in presentation layer.
I am missing basics :(
Thanks for the post
Satya
"--CELKO--" wrote:

> This is called violationof First Normal Form and good SQL programmers
> do not do it. Display is handled in the front end in a tiered
> architecture. This is more fundamental than just SQL, so you might
> want to take a class in software engineering.
>|||"--CELKO--" <jcelko212@.earthlink.net> wrote in message
news:1111762443.359407.260920@.f14g2000cwb.googlegroups.com...
>..........'good SQL programmers'
A contradiction in terms? What do you think C.Date would say about this:)