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 Delete or Drop View	SQL
2	Sql Query To Retrieve Employees Data	SQL
3	Sql Query To Use a ' SELECT ' statement with SUM() function.	SQL
4	Sql Query To Use a ' SELECT ' statement with AND Operator	SQL
5	Sql Query To use CHECK Constraint	SQL
6	Sql query to use BETWEEN Operator	SQL
7	Sql Query to retrieve data using Order By in Ascending Order	SQL
8	Sql Query To Insert The Record In The Table Without Defining The Column Name.	SQL
9	Sql Query to Truncate Table	SQL
10	Sql Query to use a Not Null Constraint	SQL
11	Sql Query To Update Multiple Column	SQL
12	Sql Example To Rename Table Name Using Alter Command	SQL
13	Sql Query To use a ' SELECT ' statement with COUNT() function	SQL
14	Sql Case Sensitive Example 5	SQL
15	Sql Query To Use a ' SELECT ' statement with DISTINCT() function.	SQL
16	Sql Query To Use a Unique Key	SQL
17	Sql Query To Use a ' SELECT ' statement with HAVING Clause	SQL
18	Sql Query To Insert The Record In The Table By Defining The Column Name	SQL
19	Sql Case Sensitive Example 3	SQL
20	Sql Query To Use a ' SELECT ' statement with OR Operator	SQL
#	Program	Language

Sql Query To Use a Inner Joins

Similar Program

About Fresherbell

Important Links

Social Media