# 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;
      ```

      ![](https://1088158622-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4M0G87SQJ28mvsXOhL%2F-M4M0IBPb1goOGpuG1BI%2F-M4M0Lw5kTZAONIbVaXU%2F2018041428.jpg?generation=1586302927177420\&alt=media)
