Catalog
Full catalog
Resources
Blog
University
Guide
Bootcamps
Provided by
JetBrains Academy
Creators of the most popular IDEs:
IntelliJ IDEA, PyCharm
& others
Authors of
Kotlin
,
Google's preferred language
for Android
More than
11.4 million developers and 300,000 companies worldwide
use JetBrains IDEs to create their products
Pricing
For Business
Sign in
Start for free
Computer science
Fundamentals
SQL and Databases
Basics SQL
Retrieving Data
Types of JOINs
Suggested problems
Using different types of JOINs
Books in a library database
Choosing the correct type of JOIN
Online orders
Using data from two tables
Online education
Multiple tables
Types of JOINs
Diagrams
Skip topic
Theory
Diagrams
Report a typo
Match the diagrams with the types of JOINs.
A)
B)
C)
Match the items from left and right columns
Get unstuck
Comments
Get help from the community
Code snippets
See topic-related syntax examples
A
B
C
LEFT JOIN
RIGHT JOIN
INNER JOIN
119
learners liked this problem.
2
didn't like it.
What about you?
___
Create a free account to access the full topic
Sign up with Google
Sign up with GitHub
Sign up with JetBrains Account
Sign up with email
By continuing, you agree to the
JetBrains Academy Terms of Service
as well as
Hyperskill Terms of Service and Privacy Policy
.
Comments (1)
Hints (1)
Useful links (2)
Show discussion