1.2.5.1.Inner join

• Inner join:

  • Inner join displays common data from columns specified on both table with ON keyword and lists out the columns as mentioned on select

  • e.g., 條件: studentsDetails的primary key 等於 studentsBackup2的Foreign key

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