title: Best way to join parent and child tables
body: <p>I have Parent table <code>A</code>.
  <code>A</code> has few child tables such as <code>B</code>,<code>C</code>,<code>D</code>,<code>E</code>,<code>F</code>,<code>G</code>
  The child tables are not linked to each other. They are only linked to <code>A</code>.
  <code>A</code> has a key <code>Id</code> which is used as foreign key in all the child tables.</p>
  
  <p>What should be the best way to join these tables so I can create a single view on this?</p>