{"id":1485,"date":"2024-08-30T01:31:55","date_gmt":"2024-08-30T01:31:55","guid":{"rendered":"https:\/\/techkubo.com\/sql\/?p=1485"},"modified":"2025-06-02T11:29:36","modified_gmt":"2025-06-02T11:29:36","slug":"inner-join","status":"publish","type":"post","link":"https:\/\/techkubo.com\/sql\/inner-join\/","title":{"rendered":"INNER JOIN"},"content":{"rendered":"\n

SQL INNER JOIN Keyword<\/h2>\n\n\n\n

The INNER JOIN keyword returns only the rows that have matching values in both tables involved in the join. It is commonly used to combine rows from two tables based on a related column.<\/p>\n\n\n\n

<\/p>\n\n\n\n

SQL INNER JOIN Syntax<\/h2>\n\n\n\n
SELECT column_names\nFROM table1\nINNER JOIN table2\nON table1.column_name = table2.column_name;<\/pre><\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL INNER JOIN Appointments with Doctors Example<\/h2>\n\n\n\n
This query displays appointment IDs and the corresponding doctor’s last name by matching doctor_id.<\/p>\n\n\n\n
SELECT Appointments.appointment_id, Doctors.last_name\nFROM Appointments\nINNER JOIN Doctors\nON Appointments.doctor_id = Doctors.doctor_id;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\n
Try It Out!<\/a><\/div>\n<\/div>\n\n\n\n
<\/p>\n\n\n\n
SQL INNER JOIN Appointments with Patients Example<\/h2>\n\n\n\n
This query displays the appointment ID and patient’s first name for each appointment.<\/p>\n\n\n\n
SELECT Appointments.appointment_id, Patients.first_name\nFROM Appointments\nINNER JOIN Patients\nON Appointments.patient_id = Patients.patient_id;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL INNER JOIN Prescriptions with Appointments and Doctors Example<\/h2>\n\n\n\n
This query displays prescriptions with related doctor and appointment information.<\/p>\n\n\n\n
SELECT Prescriptions.medication_name, Doctors.last_name, Appointments.appointment_date\nFROM Prescriptions\nINNER JOIN Appointments ON Prescriptions.appointment_id = Appointments.appointment_id\nINNER JOIN Doctors ON Appointments.doctor_id = Doctors.doctor_id;<\/pre><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
SQL INNER JOIN Labs<\/h2>\n\n\n\n