join-is used to join two tables which have the same field and same data ty

What is the difference between join and union.

Question Posted / vishnu e s

Answer Posted / vishnu e s

join-is used to join two tables which have the same field
and same data type.
union-is to join two sql querrys....

Is This Answer Correct ?

3 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What are all types of user defined functions?

1137

How do you write an inner join query?

996

What is informix sql?

1032

Can we create a trigger on view?

946

Is inner join faster than left join?

1251

What are the types of dbms?

1024

What is ttitle and btitle?

1113

Does sqlite need a server?

1097

How do I view a sql database?

1062

Is record in oracle pl sql?

1017

What is the difference between explicit and implicit cursors in oracle?

1115

How many functions are there in sql?

1095

how to use in conditions? : Sql dba

1062

How do you optimize a stored procedure in sql?

1017

what is 'mysqlimport'? : Sql dba

1111