Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between join and union.
- 27 Answers
- 179605 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 a trigger in mysql? Define different types of trigger. : Sql dba
Why is sql important?
Can %notfound return null after a fetch?
what is innodb? : Sql dba
What is a unique constraint?
What is coalesce sql?
Does sql support programming?
What are the advantages of pl sql over sql?
How many types of cursors are available in pl/sql?
What is trigger types in sql?
Do we need to rebuild index after truncate?
What are the types of sql commands?
Can we create a trigger on view?
What is the difference between union and union all command?
Does truncate need commit?
