Skip to content

Latest commit

 

History

History
41 lines (31 loc) · 1.26 KB

README.md

File metadata and controls

41 lines (31 loc) · 1.26 KB

SQL-JOINS

Overview

This project shows the demo of relational joins. It contains all required queries for the demo.

Key Topics

Types of relations joins are explained in this project with the code demo.

  1. INNER JOIN: returns only the rows where matches were found
  2. LEFT JOIN: returns matches and all rows from the left listed table
  3. RIGHT JOIN: returns matches and all rows from the right listed table
  4. FULL OUTER JOIN: returns matches and all rows from both tables

alt text

DBMS and Table Description:

This queries have been created with the postgreSQL.

storage_sj
├── owners                    # varchar
├── item_1_sj                 # varchar
├── item_2_sj                 # varchar
├── item_3_sj                 # varchar

storage_ok
├── owners                    # varchar
├── item_1_ok                 # varchar
├── item_2_ok                 # varchar
├── item_3_ok                 # varchar

SQL DDL Description

DDL Used: drop and create

How to run:

  1. Download the Joins_demo.sql file.
  2. Follow the comments and run queries using any suitable IDE on the postgreSQL.