1-Inner Join 2-Outer Join 3-Left Join 4-Right Join 5-Self Join

What are different types of joins ?

Question Posted / amar misra

Answer Posted / amar misra

1-Inner Join
2-Outer Join
3-Left Join
4-Right Join
5-Self Join

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does a covering index work?

531

Why do we use procedures in pl sql?

522

what is cross join? : Sql dba

576

What are pl sql data types?

551

What is compound trigger?

560

Why use triggers in sql?

505

I need a function for a train ticket reservation please answer it thanks in advance

565

How many types of cursors are available in pl/sql?

586

What is not equal in sql?

511

Which is faster joins or subqueries?

554

Does access use sql?

565

Is pl sql and postgresql same?

573

How do I remove all records from a table?

570

What is application trigger?

541

What is the difference between delete, truncate and drop command?

552