title: Invalid select in group by clause in vb.net
body: <p>I am using two tables in my project. Both tables are shown in diagram. Project is in VB.net 2005 and SQL Server 2005.</p>
  <p><img src="https://i.stack.imgur.com/S6fzM.png" alt="Schema" /></p>
  <p>Here is my code:</p>
  <pre><code>SELECT 
      NorthGangotri.DName, NorthGangotri.DLName, NorthGangotri.Place, 
      NorthGangotri.add1 , donor_family_detail.* 
  FROM 
      NorthGangotri, donor_family_detail 
  WHERE 
      NorthGangotri.NGCode = donor_family_detail.NGCode 
  GROUP BY 
      donor_family_detail.NGCode
  </code></pre>
  <p>But when I try to execute it gives following error:</p>
  <p><img src="https://i.stack.imgur.com/pOgZB.png" alt="Error" /></p>