title: Inner join return multiple rows
body: <p>I have tables like this : </p>
  
  <pre><code>Cities
  id   CityName
  1    NewYork
  2    Dubai
  
  
  
  Categories
  id   CatName
  1    Gaming
  2    Health
  
  
  BusinessFullData
  id   BusName  BusCity  BusCategory
  1    NewYork  1        2
  2    Dubai    2        2
  3    Germany  1        1
  4    Egypt    2        1
  </code></pre>
  
  <p>i have try this : </p>
  
  <pre><code>Select distinct Bus.Id,Bus.BusName,Bus.BusCity,Bus.BusCategory From BusinessFullData Bus 
  INNER JOIN Categories Cat ON Bus.BusCategory = 1
  INNER JOIN Cities Cts ON Bus.BusCity= 1
  Where Bus.Id=@Id
  </code></pre>
  
  <p>But i get multiple rows. I don't know why. </p>
  
  <p>What i need is to return the Business Data (with cityName and CategoryName text). by using the id of the Bus.Id </p>
  
  <p>Thanks for explaining and help.</p>