title: SQL Query Not Working In SQL Server MS
body: <p>I am building an application on Windows Forms using SQL Server Management Studio.
  I already learned basics of SQL from w3Schools Ms SQL Engine. Now When I am trying To Use Join in SQL Server Management Studio, its throwing an exception.</p>
  <p>Here's My Query:</p>
  <pre><code>SELECT Customers.CustomerName,COUNT(Orders.OrderID) AS NumberOfOrders FROM Orders
  INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID
  GROUP BY CustomerName;
  </code></pre>
  <p>The query is working fine with w3 Ms SQL engine but not with SQL Server managment studio.</p>
  <p>The Exception/Error is:</p>
  <blockquote>
  <p>Msg 207, Level 16, State 1, Line 3 Invalid column name 'CustomerName'.</p>
  <p>Msg 207, Level 16, State 1, Line 1 Invalid column name 'CustomerName'.</p>
  </blockquote>
  <p>Both Columns i.e <code>CustomerID</code> and <code>CustomerName</code> are present in Tables.
  What am I doing wrong here?</p>
  <p><strong>SOLVED</strong>
  Using Fully Qualified Names Fixed The Issue.
  Thanks For Help :)</p>