Hi Friends, 1)Inner or Natural Join. 2)Non equi Join. 3)Self Join. an

Types of joins ?

Question Posted / reddy

Answer Posted / reddy

Hi Friends,

1)Inner or Natural Join.
2)Non equi Join.
3)Self Join.
and 4)Outer Join.

Thanks
Reddy

Is This Answer Correct ?

9 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is a primary key sql?

565

What is auto increment?

582

What does partition by mean in sql?

515

what is the stuff function and how does it differ from the replace function? : Sql dba

624

Why join is faster than subquery?

601

What are the limitations of sql express?

529

Is primary key clustered or nonclustered?

567

How do you use join?

524

What is procedure explain with program?

553

What is the difference between row level and statement level trigger?

521

What is sql entity?

532

Define a temp table?

553

What does fetching a cursor do?

616

What is data type in sql?

556

Does user triggers have entry for trigger with compilation errors?

600