What is Inner Join?

Answer Posted / g.ramesh

Inner Join is default type of join.
It produce result set, which contain's only matched rows.

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

do views contain data ?

573


What is tablix?

115


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1048


How are the unique and primary key constraints different?

555


can a table be moved to different filegroup? : Sql server administration

539






What is difference between views and stored procedures?

504


What is @@rowcount in sql?

550


What is rtm version in sql server?

519


What happens when converting big values to integers?

560


What is the difference between a function and a trigger?

561


Do you know what is similarity and difference between truncate and delete in sql?

567


What is reportserver and reportservertempdb ?

107


difference between Clustered index and non clustered index ?

565


How do I find information about the install locations for the various instances running on a computer?

545


What is difference between join and natural join?

470