Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pushpa
Join interms of database combining two or more tables.
we have many joins.
inner join,self join,outer join,cross join.
in outerjoin we have three types.
left outer join
right outer join
full outer join
if we want to join two tables--
use left outer join- get the matched columns of two tables & ramaining columns of left hand side table of the join statement.
use right outer join- get the matched columns of two tables & ramaining columns of right hand side table of the join statement.
use full outer join- get the matched columns of two tables & ramaining columns of left hand side table and right hand side table of the join statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between composite index and covering index?
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
can we have a nested transaction? : Sql server database administration
Difference between report and query parameter. Why do we need different type of parameter?
How are the exceptions handled in sql server programming?
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Do comments need to go in a special place in sql server 2005?
How would you add a section to a table?
How optimize sql query with multiple joins in sql server?
What happens if the update subquery returns no rows in ms sql server?
List all the types of user-defined functions?
What is failover clustering overview?
How to verify the port number of the sql server?
What is the primary use of the model database?
What is data set in report?
