What is the difference btween join and union

induajayrose · New User Joined: 25 Jul 2005 Posts: 28 Location: Thrissur

hai friends,
what is the difference btween join and union.if anyone knows the exact definitions and difference pls give me reply
thanks in advance,
indu

nitin4.a · New User Joined: 16 Aug 2005 Posts: 26

hello

UNOIN: this combines two or more rows and produce the result table structure that have identical structure

JOIN: This combines two or more coloumns and produce the result table structure that can be different from the base tables

regds
nitin

ANIKET · New User Joined: 28 Apr 2005 Posts: 11 Location: PUNE

hi thr,

in join you can combine number of columns from one table with number of columns from other table. whereas in union we can combine rows from two or more than two table. but for union number of column selected from first table should always equal to that of from another table.

Cheers

:takerest:

Aniket

function can't coffee without in the morning...

karthi_ind · Posted: Thu Sep 29, 2005 6:46 pm Post subject: Re: join and union

Hi

Join - Combining more than one table with respect to no of columns
Union - Merging more than one table with respect to no of rows.

In Union , the no of cols selected in the first table shld be equal to the no of cols selected in the second table.

In join, we can select any no of cols in the tables.

In Union, both tables column data types should be equal.

Corrections are welcome...

Karthi G.