weissa,

Can you answer jxflagg Last question?

I have no clue about what are your presentation requeriments and That makes it harder for me so I am guessing now:

Suppose you have

TableChild (ChildID int, ParentID int , Property varchar (100))

You Could Do:

Declare @strAllChilds varchar(4000)

Declare @MasterRecordID int

SET @MasterRecordID = X

SELECT @strAllChilds = IFNULL(@strAllChilds + ',','') + Property From TableChild Where ParentID = @MasterRecordID

SELECT @strAllChilds

Can you post more info on how are you formating the output?

Edited by - noeld on 12/24/2003 09:47:10 AM