Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 180504 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 are the different types of a subquery?
How to run sql commands in sql*plus?
What is not in sql?
What is graph sql?
What is row_number () in sql?
How do I send sql query results to excel?
What is on delete set null?
What is range partitioning?
What are primary key and foreign key and how they work?
Is sql considered coding?
What is the cause of mutating table error and how can we solve it?
Which constraints we can use while creating database in sql?
what are the performance and scalability characteristics of mysql? : Sql dba
What is a natural join sql?
What are the most important characteristics of pl/sql?
