title: How to merge data from multiple tables in SQL
body: <p><br>
  Guess I am in a complex situation. Heres the scene.<br>
  I have 3 tables in SQL Server.<br>
  Enrollment, Student, Course. (FYI, there are no foreign keys)<br>
  The table columns are<br>
  <strong>Student</strong> - StudentId, StudentName<br>
  <strong>Course</strong> - CourseId, CourseName<br>
  <strong>Enrollment</strong> - EnrollmentId, StudentId, CourseId, CourseResult  </p>
  
  <p><strong>Sample Data</strong><br>
  Student - s1, Sid<br>
  Course - c1, Science<br>
  Enrollment - 1, s1, c1, 80  </p>
  
  <p>I would want a SQL query that selects data like below</p>
  
  <p>1, s1, Sid, c1, Science, 80</p>
  
  <p>I did it hard way in the DAL layer with multiple calls to database. But would like to do it in one call, and in DB.</p>
  
  <p>Any one for the rescue!</p>