inner join, left join, right join, outter join in a SQL query

Компьютер, программы

→

Microsoft SQL (Database Query Language)

inner join, left join, right join, outter join в SQL запросе

посмотрели 6036 раз

обновлено: 7 February 2019

Таблица Users

Name

JobId

Женя

Слава

Коля

Петя

NULL

Таблица Jobs

JobName

Microsoft

Apple

Sony

inner join SQL запрос

select Users.Name,Users.JobId,Jobs.JobName, Jobs.Id from Users inner join Jobs on Users.JobId=Jobs.Id

Результат SQL запроса

Name

JobId

JobName

Женя

Microsoft

Слава

Microsoft

Коля

Apple

left join SQL запрос

select Users.Name,Users.JobId,Jobs.JobName, Jobs.Id from Users left join Jobs on Users.JobId=Jobs.Id

Результат SQL запроса

Name

JobId

JobName

Женя

Microsoft

Слава

Microsoft

Коля

Apple

Петя

NULL

← Previous topic
Select projects where the number of tasks in the project is greater than or equal to 3 (Use group by, having count in a SQL query)

Next topic →
To make the values in the column non-repeating (add numbers to the duplicate names), use the update set in the SQL query

Your feedback ... Comments ...

Объявления

SQL Examples

• Select projects where the number of tasks in the project is greater than or equal to 3 (Use group by, having count in a SQL query)

• inner join, left join, right join, outter join in a SQL query

• To make the values in the column non-repeating (add numbers to the duplicate names), use the update set in the SQL query

• How to use the SQL query to split a string into words using the delimiter in SQL Server ? Creating a Stored Function in SQL Server Management Studio

Simplify complex joins and subqueries in SQL

• Common Table Expressions (CTE) for simplify complex joins and subqueries in SQL

SQL Optimization

• Optimization, improvement of SQL queries