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.

What is bcp? When does it used?

0 Answers  

---

What is the basic functions for master, msdb, tempdb databases?

2 Answers   CSC,

---

Difference between report and query parameter.

0 Answers  

---

What is better - 2nd Normal form or 3rd normal form? Why?

2 Answers   TCS, TPK,

---

What is a sub-query? When would you use one?

3 Answers  

---

Can you link only other SQL Servers or any database servers such as Oracle?

1 Answers  

---

Questions on identity?

2 Answers   Infosys,

---

How to count groups returned with the group by clause in ms sql server?

0 Answers  

---

What is bcp? When does it use?

0 Answers  

---

Is a primary key unique?

0 Answers  

---

What is dbcc? Give few examples.

0 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---