wht is d/f between union and joins ?

Question Posted / visu.kanchamreddy

2 Answers
6514 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

wht is d/f between union and joins ?..

Answer / lu

union for the row...
joins for a column...

Is This Answer Correct ?

6 Yes

2 No

wht is d/f between union and joins ?..

Answer / amarnath reddy

use unions, merge the rows from morethan one table.
Ex: select accno.,accname from bank1;
union
select accno.,accname from bank2;

use Joins, merge the columns from morethan one table.
Ex: select i.accno., d.bcode from banktab i, dtlstab d
where i.bcode=d.bcode;

Is This Answer Correct ?

4 Yes

1 No

Post New Answer

More DB2 Interview Questions

I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?

6 Answers Perot Systems,

What is performance tuning db2?

0 Answers

Is it possible using max on a char column?

0 Answers

What techniques will be used to avoid deadlock??

5 Answers IBM, SUN,

What is the physical storage length of timestamp data type?

0 Answers

What does it mean if the null indicator has -1, 0, -2?

1 Answers

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers

What is QUIESCE?

2 Answers

how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token

2 Answers IBM, TRD,

Update command

1 Answers

What are the 4 environments which can access DB2 ?

2 Answers

What is the database descriptor?

2 Answers

For more DB2 Interview Questions Click Here