Diff. b/w Full Outer Join And Cross Join?

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


Please Help Members By Posting Answers For Below Questions

What does truncate do?

510


Can foreign key be deleted?

500


How to name query output columns in ms sql server?

521


What are the differences between decimal and float in ms sql server?

545


What are pessimistic lock and optimistic lock?

527






What is order of B+tree?

629


How to loop through the result set with @@fetch_status?

638


Do you know what is user defined datatypes and when you should go for them?

478


explain different types of backups avaialabe in sql server? : Sql server database administration

568


Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

477


What is #table in sql server?

513


What is trigger explain with program?

508


What is optimization and its types?

514


Where are sql server usernames and passwords stored in the sql server?

593


What is data source document?

525