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
How to configure odbc dsn with different port numbers?
Sql server reporting services vs. Crystal reports.
What are sparse columns?
what stored procedure would you use to view lock information? : Sql server administration
Is mysql the same as sql server?
Explain how many types of relationship?
Can foreign key be duplicate?
Do you know the cursor optimization tips?
Differentiate between ms sql server reporting services vs crystal reports?
Explain the truncate command?
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
Should you normalize audio?
How to turn off warning messages during php execution?
How to delete an existing database user?
How do I connect to sql server database?
