Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / saurav kumar
Full outer join will give common + uncommon records from
both the table.
Suppose in TableA I have 5 records and TableB have 6
records. Both the table have 4 common records, means 4
records of TableA is common with TableB.
Then full outer join will give 4(common) + 1 (TableA)+ 2
(TableB) = 7 records.
Whereas Cross Join will give 5(TableA) * 6(TableB) = 30
records, also we can't put 'ON' condition with cross join.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Data table as parameter in sql server?
Do you have any idea about the tcl commands?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What is an entity-relationship diagram (erd)?
What happens if you add a new index to large table?
State a few properties of relational databases?
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
What is sqlcmd?
When cursors are useful?
what is a correlated sub-query? : Sql server database administration
Explain what is the difference between union and union all?
How to check table values in sql server?
Suggest a method of joining two tables.
Define inner join? Explain with an example?
