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 the difference between OLEDB and ODBC

4 Answers   CFCI,

---

What do you mean by cardinality?

0 Answers  

---

What is perspective, have you ever created perspective? : sql server analysis services, ssas

0 Answers  

---

How to insert new line characters into strings?

0 Answers  

---

How real and float literal values are rounded?

0 Answers  

---

How to integrate the ssrs reports in application?

0 Answers  

---

Explain the cursor lock types?

0 Answers  

---

What are trace flags?

0 Answers  

---

HOW TO RENAME A COLUMN NAME

3 Answers  

---

What is query cost in sql server?

0 Answers  

---

List out the differences between global and local temp tables in sql server?

0 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---