Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help with Select query

Status
Not open for further replies.

lllyxer

Programmer
Nov 22, 2006
22
US
Hello ,

I have a table WORDS.

Word_id | word_name | word synonym
1 | oval | egg-shaped
2 | oval | rounded
3 | voyage | travel
4 | voyage | journey
5 | voyage | trip


In the output I’m looking to have two fields word_name and word_synonym, but values in word_synonym field will be comma delimited.

world_name | world synonym
oval | egg-shaped, rounded
voyage | travel, journey, trip

Thank you
 
Start here: thread183-1159740

Post back if you have any additional questions.


-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top