Answer / saravakumar

A join selects columns from 2 or more tables. A union
selects rows.

Answer / sree

UNION:The SQL UNION operator combines two or more SELECT
statements.

JOINS:SQL joins are used to query data from two or more
tables, based on a relationship between certain columns in
these tables.

Answer / nikhila reddy

UNION:the both tables should have same structure and datatype.
the column name will taken as first table ones it wont bother abt other tables.
example:
emp table as
eid ename esal
1 a 10k
2 b 20k

dept table as
deptid deptname deptsal
11 aa 20k
12 bb 50k


select * from emp
union
select * from dept

empid empname empsal
1 a 10k
2 b 20k
11 aa 20k
12 bb 50k

now u can observe col name taking alias of first table.
no need of relation between a tables.
it will remove duplicate records.


joins:it will join only required fields from different tables.
no need of same structure for tables..
it should have relation between a tables.

select names starts with a,b,c

8 Answers   Scope International,

---

Tell me the difference between clustered and non-clustered index?

0 Answers  

---

what is the primary use of the model database? : Sql server administration

0 Answers  

---

What is difference between stored procedure & function?

3 Answers   CarrizalSoft Technologies, Concept Infoway, TATA,

---

How do I make a resultset scrollable?

0 Answers  

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

---

How can i Relate Tables in SSIS

0 Answers   HCL,

---

Does group by or order by come first?

0 Answers  

---

Explain triggers?

0 Answers  

---

Explain system rowset functions?

0 Answers  

---

Explain how dts is used to extract, transform and consolidate data?

0 Answers  

---