In Need of a Keyword - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

In Need of a Keyword

Author

Topic

cardgunner

326 Posts

Posted - 2008-02-21 : 09:35:51

I want to search this forum for articles but I don't know what it's called that I'm looking for.

What do you call it when you want to join fields in different records in one record.

Example the table below, tbl1, has 6 records, 3 columns,


ID |  Word | SEQ
2       MY    2
3     JUMBLE  1
4     TYPING  2
5      HAIRY  3
6     STINKS  2
7     POKER   1

I would like to create a query that gives my
MY TYPING STINKS

What is it called that I am trying to do? I thought it was collate but from the first couple of forums i looked at it wasn't, or is it?

Card Gunner

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2008-02-21 : 09:39:38

Looking for something like this?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53293

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"