Return list of people with multiple languages spoken 2

[prover]

My brain is mush. I know this has got to be simple but right now simple things escape me...

I have "Person" table" and a "Language" table with a one to many relationship. I want to return a list of persons and any language spoken (if any) similar to below:

Name Address Position Languages
jim brown 1 Test Dr Manager Spanish, French
mary smith 2 test dr clerk Spanish
paul jones 3 test dr clerk

TIA

 

[monksnake]

This will work if there are no duplicate rows between Name and Language.

select Name from Person group by Name having count(Name) > 1

<.

 

[mrdenny]

You need to use a function to colapse the languages into a single field in the users row. This forum should have several examples on how to do it. Check out the Search feature above.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[gmmastros]

To return a comma delimited list of languages, I recommend you take a look here: thread183-1159740



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[prover]

duh...

a function!!!

I knew it was simple

Never argue with an idiot. He'll just drag you to his level and beat you with experience!

 

[monksnake]

My brain is mush, I just the subject and started writing.

<.

 

[mrdenny]

Standard disclaimer...

Performance of functions can suck.

Your disclaimer ends here.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com