SQL Join | Sharp Tutorial

table join

A JOIN clause is used to combine two or more tables, based on a common column .Below examples shows how we can fetch data from two tables

Following query display the student name , course name, and fee from student and course table where course is ‘BCA’

select student.name, course.courseName , course.fee
 from (student, course)

where course.courseName='BCA' and course.courseId =student.courseId ;