View previous topic :: View next topic
|
Author |
Message |
induajayrose Warnings : 2 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 |
|
Back to top |
|
|
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 |
|
Back to top |
|
|
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... |
|
Back to top |
|
|
karthi_ind
Active User
Joined: 24 Feb 2004 Posts: 131 Location: Chennai
|
|
|
|
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. |
|
Back to top |
|
|
|