Join Help - 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)

Join Help

Author

Topic

jrockfl
Posting Yak Master

223 Posts

Posted - 2007-01-12 : 21:35:30

I have a users table
Users
UserID User Email
1 jason myemail

Next I have an email table
EmailID EmailName
1 Reminder Email
2 Late Email

Finally a lookup table
UserID EmailID
1 1
1 2

So now when I join the tables I get 2 records, that's understandable.
UserID User EmailID
1 Jason Reminder Email
1 Jason Late Email

How can I do this..
UserID User EmailType
1 Jason Reminder Email; Late Email

The emails are combined in there own column

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-13 : 04:50:14

you required to concatenate the rows value into column. See this http://sqljunkies.com/WebLog/amachanic/archive/2004/11/10/5065.aspx

jrockfl
Posting Yak Master

223 Posts

Posted - 2007-01-15 : 06:52:23

Thank you! I will look into that.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources