如何从SQL Server 2008返回XML，该XML由多个选择共享一个公共父级构成

I've tried using "FOR XML PATH", "FOR XML EXPLICIT" and "FOR XML AUTO" but the data is never structured with the correct heirarchy.I've tried using "FOR XML PATH", "FOR XML EXPLI