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
Explain about service Broker functions?
What are the differences between sql server and mysql.
Explain nested trigger in sql?
What is temporal data type?
What is transaction server implicit?
Define Business Edition in SQL Azure?
what is a mixed extent? : Sql server administration
How to retrieve field values using mssql_result()?
Explain how dts is used to extract, transform and consolidate data?
What are the tools available in market as an alternative to sql server reporting services?
What is ms sql server service broker?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What are basics of policy management?
where can you add custom error messages to sql server? : Sql server administration
What do you understand by recursive stored procedure?