Transfer from Row data to Column data

[Hendra]

I have these rows returned from a select statement:

TABLE A
ObjectNo ObjectName
1 "Things A"
2 "Things B"
3 "Things C"

My question is what is the fastest way to put those row data to table
with 3 column. So the result will be

TABLE B
ObjectNo ObjectA ObjectB ObjectC
11 "Things A" "Things B" "Things C"

Thank you,
Hendra

[Simon Hayes]

"Hendra" <hkus...@polymorphia.com> wrote in message
news:734185f4.0308...@posting.google.com...

It's probably easiest to do the transformation on the client - see the
thread "newbie sql query question" from a few days ago in this group for
more discussion.

Simon