title: Fill DataTable with many SQL Tables and add a new column to know from which table
body: <p>I am using vb.net and I need to query 4 SQL Tables and write the output to a DataTable. 
  So I am doing this (example with 2 Tables), and it works fine:</p>
  
  <pre><code>    If CBbf.Checked = True Then
          pgCommand.CommandText = "Select * FROM ""bf"" WHERE LOWER(""devname"") Like LOWER('" &amp; TBname.Text &amp; "%')"
          sda = New NpgsqlDataAdapter(pgCommand)
          sda.Fill(dtRecord)
      End If
  
      If CBhp.Checked = True Then
          pgCommand.CommandText = "Select * FROM ""hp"" WHERE LOWER(""devname"") Like LOWER('" &amp; TBname.Text &amp; "%')"
          sda = New NpgsqlDataAdapter(pgCommand)
          sda.Fill(dtRecord)
      End If
  </code></pre>
  
  <p>Now I would like to add a Column on each query, so that I know from which Query the output comes from.</p>
  
  <p>e.g.:</p>
  
  <p><a href="https://i.stack.imgur.com/9hS7V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9hS7V.png" alt="enter image description here"></a></p>
  
  <p>So I would like to know how I can add the "from" column and fill the values according to the query I am doing. </p>
  
  <p>Thank you!</p>