What is the difference between join and union.
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
Is stored procedure faster than query?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is left join example?
What sql does db2 use?
Explain scalar functions in sql?
Explain the significance of the & and && operators in pl sql.
Why is %isopen always false for an implicit cursor?
What is pl sql block in dbms?
How do I audit the sql sent to the server?
which types of join is used in sql widely? : Sql dba
What is data type in sql?
What if we write return in procedure?
How to use sql statements in pl/sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What are triggers and its types?