title: sql concat columns from different tables
body: <p>I'm looking to create a view that concatenates two columns from two tables together. the scenario is as follows:</p>
  
  <p>Table1 - Parent</p>
  
  <pre><code>Id
  fname
  lname
  age
  </code></pre>
  
  <p>Table2 – child</p>
  
  <pre><code>Id
  parent_id
  fname
  age
  </code></pre>
  
  <p>view – child</p>
  
  <pre><code>Id
  firstlast
  age
  </code></pre>
  
  <p>Given that the child table has a fk reference to parent’s ID, and parent has a lname column that I’m interested in, how would one create a view that contains</p>
  
  <p>child(id),</p>
  
  <p><code>child(fname)</code> . <code></code> . <code>parent(lname)</code> as fullname</p>
  
  <p>child(age)</p>
  
  <p>the fullname would appear 'Jimmy Smith'</p>