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
what is the difference between truncate and drop statements? : Sql dba
Is primary key is clustered index?
What is exception? What are the types of exceptions?
What are the types of variables use in pl sql?
What is offset and limit in sql?
What are the uses of merge?
Difference between truncate, delete and drop commands?
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is synchronized subquery?
what are the types of join and explain each? : Sql dba
Are sql database names case sensitive?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
what are date and time functions in mysql? : Sql dba
How to return an array from java to pl/sql?
Is natural join and inner join same?