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
How to connect php with different port numbers?
How to use "begin ... End" statement structures in ms sql server?
How can we use ConnectorJ JDBC Driver with MS SQL?
Explain DBCC?
Which sql server table is used to hold the stored procedure script?
What does it mean to invest in the index?
What is dbcc updateusage?
What is user-defined function?
What are the advantages to use stored procedures?
what are the core components of SSRS?
How to get the query of a table in sql server?
How and why use sql server?
Do you know what are the reporting services components?
What is the xml datatype?
What is a virtual table in sql?
