What is meant by Join? What are the different types of
Joins available? Explain.

Answer Posted / mahesh

joins are used to relate two tables and display the result..

Types of join

1.inner join
2.outer join
2.1 left outer join
2.2 right outer join
2.3 full outre join
3.cross join

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an example of translating a date into julian format?

569


What are stored procedures used for?

528


Describe different types of general function used in sql?

528


Why do we need view in sql?

543


How do I remove sql developer from windows 10?

501






what are integrity rules?

560


What is the difference between microsoft access and sql server?

525


define sql update statement ? : Sql dba

561


Why is sql important?

575


What are aggregate and scalar functions?

520


What is nosql example?

579


Which one is better sql or oracle?

491


What is the main reason behind using an index?

544


what is a trigger? : Sql dba

568


explain normalization concept? : Sql dba

582