1.2.5.3.Right join

• Right join displays common data from columns specified on both table with ON keyword along with all data from first table (right table) and lists out the columns as mentioned on select

• 以第二個table為主, 加入第一個table

select * from studentsdetails right join studentsbackup2 on studentsdetails.id = studentsbackup2.student_id;