1.2.5.2.Left join

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

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

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