updating a field with multiple column values

[vlitim76]

I have the below situation:

table1

t1ID
t1Name

table2

t1ID
t3ReqID

table3

t3ReqID
t3Name

Where t1ID can be linked to multiple t3ReqID's.

I want to be able to bring back a recordset that looks like:

t1ID
t1Name
requirements

where requirements is a comma delimited list of t3Name

how do you do this without using a cursor?

Cheers

 

[Catadmin]

See my FAQ faq183-6466 for two different, non-cursor, methods for doing what you want.



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"