Please let me know if UNION ALL and Natural Join does the
same operation and are same...

Answer Posted / vasanth

Natural Join and UNION ALL won't give same results.

Is This Answer Correct ?    15 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is an alias command? : Sql dba

727


how to create a new table by selecting rows from another table in mysql? : Sql dba

753


what is unique key constraint? : Sql dba

742


Mention what does the hierarchical profiler does?

733


What is the difference between union and union all command?

740






How can I tell if sql is running?

761


What is t sql used for?

733


what are the difference between clustered and a non-clustered index? : Sql dba

731


What is a dirty read sql?

715


How can triggers be used for the table auditing?

753


what is the difference between $message and $$message? : Sql dba

741


Can we use update in sql function?

772


what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

765


Describe different types of general function used in sql?

727


How can I speed up sql query?

707