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 user defined views?
What is sql server transaction log file?
What do you mean by a Composite primary key?
what is the difference between Tabular and Matrix report?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is the difference between implicit and explicit transaction?
What gets stored inside msdb database?
How to use old values to define new values in update statements in ms sql server?
How does a profiler work?
Explain comment on transactions?
What is usually the first word in a sql query?
What is indexing a document?
How to list all user names in a database?
Which autogrowth database setting is good?
What to check if a User database is locked?