Sql Query To Use a Inner Joins

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.

Here we are performing inner joins between employees and the job_history table, that having matched column employee_id value.

In second query we only use AS or Alias

Database

Theme

Enter - Select * from table_name;

SQL Query

SELECT 'Using Inner Joins'; SELECT first_name,email,salary,start_date,end_date FROM employees inner join job_history WHERE employees.employee_id = job_history.employee_id; SELECT 'Using Inner Joins as Alias'; SELECT e.first_name,e.email,e.salary,jh.start_date,jh.end_date FROM employees as e inner join job_history as jh WHERE e.employee_id = jh.employee_id;

Output

Similar Program

#	Program	Language
1	Sql Query To Retrieve Record Using Where Condition	SQL
2	Sql Query to use a Not Null Constraint	SQL
3	Sql Case Sensitive Query Without Semicolon	SQL
4	Sql Query To Insert The Record In The Table By Defining The Column Name	SQL
5	Sql Query To Use a ' SELECT ' statement with GROUP BY Clause	SQL
6	Sql Query To use CHECK Constraint	SQL
7	Sql Example to create table and insert data into it	SQL
8	Sql Query to retrieve data using Order By in Ascending Order	SQL
9	Sql Query to Truncate Table	SQL
10	Sql Query To Use a ' SELECT ' statement with Alias or 'AS"	SQL
11	Sql Query To Use a ' SELECT ' statement with LIKE Clause	SQL
12	Sql Query To Add Column Using ADD With ALTER Command	SQL
13	Sql Query To Use a ' SELECT ' statement with AVG() function.	SQL
14	Sql Query To Use a ' SELECT ' statement with DISTINCT() function.	SQL
15	Sql Query To Update Multiple Column	SQL
16	Sql Update Query Without Where Condition	SQL
17	Sql Query to retrieve data using Order By in Random Order	SQL
18	Sql Case Sensitive Example 3	SQL
19	Sql Query to retrieve data using Order By in Descending Order	SQL
20	Sql Query To Insert The Record In The Table Without Defining The Column Name.	SQL
#	Program	Language

Sql Query To Use a Inner Joins

Similar Program

About Fresherbell

Important Links

Social Media