Join SQL Tutorial

Join Example:

SELECT s.student_id, s.name, b.book_id, b.price
FROM students s, books b
WHERE s.student_id = b.student_id
AND b.price > 90 ;

Students table:

STUDENT_IDNAMEYEAR
1STUDENT_1I
2STUDENT_2II
3STUDENT_3III
4STUDENT_4IV

Books table:

BOOK_IDSTUDENT_IDPRICE
1140
2250
3370
41100
52120
6490
73200
82150

Join Result:

STUDENT_IDNAMEBOOK_IDPRICE
1STUDENT_14100
2STUDENT_25120
3STUDENT_37200
2STUDENT_28150