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

Answer Posted / ramesh

Full Outer Join requires a condition and related column in
the table.
Cross Join requires with out condition and no related
columns in the tables.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I tell if sql server is 32 or 64 bit?

707


What is triggers and stored procedures?

689


Tell me what is a linked server?

767


What are the different authentication modes in sql server? How can it be changed?

774


Differentiate between sql temp table vs table variable?

667






Explain the advantages of merge replication?

680


What are the commands used in DCL?

713


What is NOT NULL Constraint in sql server 2012?

751


How do we Backup SQL Azure Data?

98


What is subquery explain with example?

796


Do you know what guidelines should be followed to help minimize deadlocks?

721


What is difference between rownum and rowid?

670


how can a database be repaired? : Sql server administration

689


What happens if the update subquery returns multiple rows in ms sql server?

787


How do I view a procedure in sql server?

750