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

What are indexes in ms sql server?

556


What are the types of subscriptions in SQL Server replication?

554


How can you tell if a database object is invalid?

619


How display code or Text of Stored Procedure using Sql query in Sql Server ?

613


What is the process of normalization?

562






you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

553


Explain about local stored procedure?

510


What is cached report?

106


What is cube dimension? : sql server analysis services, ssas

538


What does select 1 mean?

534


Does index slows down insert statements?

586


How much does sql server 2016 cost?

539


When I run the sql server 2000 setup, it just hangs. What do I do?

654


Describe in brief system database.

547


What is the difference between cube operator and rollup operator? : SQL Server Architecture

629