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 are the features of Embedded SQL
What are different types of table joins?
What are the different types of join?
Difference between connected and disconnected database in .net with sql server?
What are sub reports?
What is a hint?
What is the difference between ‘having’ clause and a ‘where’ clause?
What are the security related catalog views? : sql server security
Can you always create a cache of a report?
Define cross join in sql server joins?
How to see existing views in ms sql server?
Write a code to select distinct records without using the DISTINCT keyword.
Explain the difference between functions and stored procedures in sql server?
What are the types of sql server?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
