title: Is there a way to combine count and select query?
body: <p>Hello i have two database tables, for this example im using table <strong>Article</strong> and <strong>Comment</strong>. </p>
  
  <p>Here is schema:<a href="https://i.stack.imgur.com/AYTvn.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AYTvn.png" alt="enter image description here"></a></p>
  
  <p>Is there a way to count <code>Comments</code> based on <code>FK_Article</code> and then counted values add to standart <code>select</code> query on <code>Article</code> table?</p>