title: How to select from multiple tables with no matching columns
body: <p>I want to query between three tables that have no matching columns .I have used <code>UNION</code> but it replace <code>idDisplayNetwork</code> and <code>idDevice</code>  with <code>idCountryin</code> the result.</p>
  
  <pre><code>SELECT idcountry, 
         name 
  FROM   country 
  UNION 
  SELECT iddevice, 
         name 
  FROM   device 
  UNION 
  SELECT name, 
         iddisplaynetwork 
  FROM   displaynetwork 
  </code></pre>
  
  <p>I want this kind of output</p>
  
  <pre><code>   { idCountry: '18ec1e07-9c89-4d2c-aefe-a7bd8966fab4',
      Name: 'Russia' },
     { idCountry: '31ceda51-9ce8-4380-bd41-c95f660e2ad4',
      Name: 'Turkey' },
     { idDevice: 'c0180c24-2df5-4082-b050-94dfaf1d5174',
      Name: 'Desktop and Laptops' },
    { idDisplayNetwork: '771434a0-0e6d-4206-90f5-f6abf85690d1',
      Name: 'search network' },
  </code></pre>
  
  <p>Any help will be appreciated.</p>