SQL statement question

[Krzemo]

CREATE FUNCTION dbo.FN_GetConcatedNames(@i_ID INT) RETURNS VARCHAR(4000)
AS
BEGIN
DECLARE
	@_Str VARCHAR(4000)
SELECT @_Str=''
 
SELECT @_Str=@_Str+IsNull(','+t2.[Name],'') 
	 FROM Table3 t3,Table2 t2
	 WHERE t3.ID_Table2=t2.ID AND T3.ID_Table1=@i_ID
 
RETURN SUBSTRING(@_Str,2,4000)
END
 
GO
 
SELECT T1.Name,dbo.FN_GetConcatedNames(T1.ID) Names2
FROM Table1 T1

Hope it helps.