title: Is it possible to make an auto join of tables by foreign keys
body: <p><strong>What do i mean?</strong><br/><br/>
  I'm looking for elegant way that Sql-engine will join for me automatically columns by keys and relationships that already familiar to the Sql-engine server when I created those tables.
  <br/><br/>
  I know I can create query code with inner join for all the tables and mess with to many code (if it's a lot of tables or/and the query is dynamic).<br /></p>
  
  <p>Those who worked with access before probarly noticed that access has a "plus" icon on the result grid which allows to expand the item and see the objects "under" the foreign key.
  <br/><br/>
  It looks like that: (In this figure you can see that under the "1" number there are 3 rows on another related table).
  <img src="https://i.stack.imgur.com/CLoME.png" alt="enter image description here"></p>
  
  <p><br/>
  I'm looking the same thing on sql management.</p>
  
  <p>I tried to google about it but I didn't found an expression for that action.</p>