Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180595 Views
- 3i Infotech, ABC, Oracle, Polaris, TCS, XT Global, I also Faced
- E-Mail Answers
Answer Posted / nitin
for SET operators the resultant column set should be same for the tables.
i.e.
select * from boy
union
select * from girl
will give an error if they have different column
but in join you can corellete the column to each other.
select * from boy,girl where boy.id_gender=girl.id_gender;
will give result
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is auto increment in sql?
How does sql*loader handles newline characters in a record? : aql loader
How to make a copy values from one column to another in sql?
What does plv msg allows you to do?
What is use of trigger?
What is pl sql architecture?
Can we change the table name in sql?
Why we use sql profiler?
Does pl sql work in mysql?
What does the base_object_type column shows in the user.triggers data dictionary view?
Which join is default?
Name the operator which is used in the query for pattern matching?
What is the requirement of self-join?
Is mariadb nosql?
How do I save a sql query?
