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

How to avoid using cursors?

1038

Which are the different case manipulation functions in sql?

952

How do you determine the current isolation level? : Transact sql

1067

What is sqlcommand?

962

How to return an array from java to pl/sql?

1061

How do you update a table in sql?

924

Mention what plvcmt and plvrb does in pl/sql?

1061

Can we connect to postgresql using sql developer?

934

What do you understand by pl/sql records?

959

What are its different types of dbms?

955

What is a primary key? Explain

920

What are the dml statements?

1095

Which is faster count (*) or count 1?

964

Which is better trigger or stored procedure?

880

Can primary key be changed?

869