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
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How sql server executes a statement with nested subqueries?
How you can find out if an index is useful to the optimizer?
What happens if we shrink log file in sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
How does the report manager work in SSRS?
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
please differentiate between delete and truncate?
What are the differences between decimal and float in ms sql server?
How to optimize stored procedures in sql server?
What are the different types of backups avaialabe in sql server 2005?
What is triggers and its types?
What are window functions in sql server?
What is a filestream?
what are different types of backups available in sql server? : Sql server database administration