DEV Community

Lam
Lam

Posted on

Sql Joins Cheat Sheet

#sql #cheatsheet

Diagram 

SELECT * FROM `A` INNER JOIN `B`
Enter fullscreen mode Exit fullscreen mode 
┌────────┐
│ A  ┌───┼────┐
│    │ ∩ │    │
└────┼───┘  B │
     └────────┘
Enter fullscreen mode Exit fullscreen mode
Join What
Inner join ∩
Left outer join A + ∩
Right outer join ∩ + B
Full outer join A + ∩ + B

Example 

SELECT * FROM order_items \
  LEFT OUTER JOIN orders \
  ON order_items.order_id = orders.id
Enter fullscreen mode Exit fullscreen mode

Joins are typically added to SELECT statements to add more columns and records.

Reference

Top comments (1)

Collapse
 
socoladaica profile image
Socola Đại Ca • • Edited

Advanced

Read next

esproc_spl profile image

Java, perform COUNT on each group of a large csv file #eg33

Judy -

mrcaption49 profile image

Common Table Expression (CTE) in PLSQL | Part 1

Pranav Bakare -

trixsec profile image

List of the best Google Dorks in 2024 for finding SQL injection vulnerabilities and other security issues:

Trix Cyrus -

leandro_nnz profile image

Understanding and Configuring Oracle Access Control Lists (ACLs) for Email Sending Using UTL_MAIL

Leandro Nuñez -