title: Union select statements horizontally
body: <p>let's say result of my select statements as follows (I have 5 of those):  </p>
  
  <pre><code>   Id  Animal AnimalId
      1   Dog     Dog1
      1   Cat     Cat57
  
     Id  Transport TransportId
      2   Car        Car100
      2   Plane      Plane500
  </code></pre>
  
  <p>I'd like to get a result as follows:</p>
  
  <pre><code>   Id  Animal AnimalId    Transport    TransportId
      1   Dog     Dog1
      1   Cat     Cat57
      2                        Car          Car100
      2                       Plane         Plane500 
  </code></pre>
  
  <p>What I can do is I can crate a tablevariable and specify all possible columns and insert records from each select statement into it. But maybe better solution like PIVOT?<br>
        <strong>Edit</strong></p>
  
  <p>queries: 1st: <code>Select CategoryId as Id, Animal, AnimalId from Animal</code><br>
  2nd: <code>Select CategoryId as Id, Transport, TransportId from Transport</code></p>