Types of Joins

Inner Joins: Theta, Natural, EQUI

Outer Join: Left, Right, Full

Inner Joins

Theta Join

Syntax

A ⋈θ B

Natural Join

EQUI join

Outer Join

Left Outer Join

Syntax

A Left Outer Join B

Right Outer Join

Syntax

A Right Outer Join B

Full Outer Join

Syntax

A Full Outer Join B

 

 

 

 

Categorized in:

DBMS

Tagged in:

, , , , , , , , , , , , , ,

Share Article:

Leave a Reply

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock