using System;

using System.Collections;

using System.Collections.Generic;

using System.Linq;

using System.Xml;

using System.Xml.Linq;

using System.Linq.Expressions;

using System.Text.RegularExpressions;

using System.Reflection;

​

namespace ConsoleApplication9

{

    public class Program

    {   

        public static void Main(string[] args)

        {

            string xml = 

                @"<SqlRoot>

  <SqlStatement>

    <Clause>

      <OtherKeyword>select</OtherKeyword>

      <WhiteSpace></WhiteSpace>

      <Other>t1</Other>

      <Period>.</Period>

      <Other>empid</Other>

      <WhiteSpace></WhiteSpace>

    </Clause>

    <Clause>

      <OtherKeyword>from</OtherKeyword>

      <SelectionTarget>

        <WhiteSpace></WhiteSpace>

        <Other>bd_orm</Other>

        <Period>.</Period>

        <Other>dbo</Other>

        <Period>.</Period>

        <Other>bal_impacts_t</Other>

        <WhiteSpace></WhiteSpace>

        <Other>t1</Other>

      </SelectionTarget>

    </Clause>

  </SqlStatement>

</SqlRoot>";

            var xDoc = XDocument.Parse(xml);

            var nodes = (from res in xDoc.Descendants("Clause").Descendants("SelectionTarget").Descendants() select res);

            var name = String.Join("", nodes.Select(n=>n.Name == "WhiteSpace"?" ":n.Value));

            Console.WriteLine(name);

            Console.WriteLine();

            foreach(var n in nodes)

                Console.WriteLine(n);

        }

    }

}