What is a join and their types?

Answer Posted / s.chithiravelu

Join can be defined as an operation that includes the
retrieval of data from more than one table at a time.

Various Types of Joins:

Inner Joins
Outer Joins
Cross Joins
Equi Joins
Natural Joins
Self Joins

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the index requirement in SQL Azure?

72


How to turn on the mssql api module in php?

573


Can we add an identity column to decimal datatype?

591


How to find index size for each index on table?

593


What are different types of replication in sql server?

578






What are the instances when triggers are appropriate?

532


what is checksum in sql server.........???

1211


What is the maximum size of a dimension? : sql server analysis services, ssas

568


Explain the benefits of user-defined functions?

534


What is ms sql server index?

569


How much space does sql server 2016 take?

571


How to create prepared statements using odbc_prepare()?

575


What do you mean by cardinality?

505


What do you think of this implementation? Can this be implemented better?

545


Why should we go for stored procedures? Why not direct queries?

580