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 can triggers be used for the table auditing?

592

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

615

What is normalization in a database?

610

what is sql in mysql? : Sql dba

569

How do I count records in sql?

514

Mention what are the benefits of pl/sql packages?

532

Can a key be both primary and foreign?

508

Explain the difference between drop and truncate commands in sql?

527

What is spool?

588

Can you join views in sql?

538

what is cursor. write example of it. What are the attributes of cursor.

743

What is cte?

570

How can we make an if statement within a select statement?

536

what is schema? : Sql dba

560

What is cross join example?

549