What is Inner Join?

Answer Posted / prasanna

Inner joins use a comparison operator(like = or <>)to match
rows from two tables based on the values in common columns
from each table.It is a default type of join.
These includes Equi Joins and Natural Joins.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to name query output columns in ms sql server?

621


How do I delete a sql server database?

634


What is tcl in sql server?

744


What is a mutating table error and how can you get around it?

618


Is it true, that there is no difference between a rule and a check constraint?

593






how many clustered indexes can be created on a table? : Sql server database administration

659


what data regions are and what are the different data regions?

107


How will you hide an attribute? : sql server analysis services, ssas

608


What is the difference between getdate and sysdatetime?

631


How to receive output values from stored procedures?

588


What is the stuff?

619


What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

561


What is the maximum number of index per table?

660


List types of tables in SQL Azure?

116


What is the difference between ‘having’ clause and a ‘where’ clause?

651