Join - joining of two tables to itself. types of joins..... simple/equi/

What is meant by Join? What are the different types of
Joins available? Explain.

Question Posted / udaykumar

Answer Posted / udaykumar

Join - joining of two tables to itself.
types of joins.....
simple/equi/inner
self
outer
cartesian.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a boolean in sql?

1025

How do I use google cloud in sql?

1144

How do I view tables in sql developer?

1009

How do I partition a table in sql?

1207

What are aggregate and scalar functions?

1085

What is a primary key sql?

1093

How does postgresql compare to mysql?

1079

What is the difference between nvl function, ifnull function, and isnull function?

1154

What is sql basics?

1081

Can we use commit inside a trigger?

1147

State few characteristics of pl/sql?

1022

How would you pass hints to the sql processor?

1040

Can we create view in stored procedure?

1026

Can we use rowid as primary key?

1043

Why do we use %rowtype & %type in plsql?

1097