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

Is primary key is clustered index?

1047

What is pessimistic concurrency control? : Transact sql

1140

What is cursor and why it is required?

1258

How do you optimize a stored procedure in sql?

1019

What are the datatypes available in pl/sql ?

1158

Is pl sql useful?

1039

What are three advantages to using sql?

1074

Can pl sql procedure have a return statement?

1072

what does the t-sql command ident_current does? : Transact sql

1050

What packages are available to pl/sql developers?

1113

How to change sql*plus system settings?

1115

What is a schema? How is it useful in sql servers?

1179

what are properties of a transaction? : Sql dba

1142

Why should I use postgresql?

1070

Which data dictionary views have the information on the triggers that are available in the database?

1301