Inner Join is used to retrieve the only record, that having matched column value (e.g id) on both tables.
We can perform inner joins in multiple tables.
The syntax for inner joins is-
table_1 INNER JOIN table_2
table_1.column_name = table_2.column_name;
employees.employee_id = job_history.employee_id;
Better to use AS (Alias) for the long table name-
employees as e
job_history as jh
e.employee_id = jh.employee_id;
Here we will get only those records where employee_id will get matched in both employees and job_history table.
Other records that is not matched will not get retrieved.
Best learning portal that provides you great learning experience of various technologies with modern compilation tools and technique
Don't hesitate to give us a call or send us a contact form message