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 keys and its types?

1083

What is the order of sql select?

1047

What is cold data?

968

How many sql commands are there?

1127

how to create a new table in mysql? : Sql dba

1000

What is varchar sql?

1156

What are procedures used for?

996

what are myisam tables? : Sql dba

1042

Mention what are different methods to trace the pl/sql code?

1223

How to use sql statements in pl/sql?

1137

What is memory optimized table?

1052

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

966

Can we use commit inside a trigger?

1103

How do I create a sql script?

1109

What is view explain with example?

940