Select........... from.... ........ where DEPT_TABLE.DEPNO = EMP

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?

Question Posted / amlan roy

6 Answers
11354 Views
Perot Systems, I also Faced
E-Mail Answers

Answer Posted / amlan roy

Select...........
from....
........
where DEPT_TABLE.DEPNO = EMP_TABLE.DEPNO.
AND DOJ between '01/01/2007' and '01/01/2008'

Is This Answer Correct ?

11 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a collection in db2?

1047

How do you select a row using indexes in db2?

1145

what is db2 restart?

2166

define clustering index.

1037

What is the clustering index in the db2 database?

1012

What are the two types of logging in the db2 database? Explain them.

1089

What is bind plan?

1060

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1087

What are the prerogatives?

1091

What is concurrency?

1243

What is temporal table in db2?

1051

What does runstats do in db2?

1132

What is the difference between spufi and qmf?

1140

How can record locking be achieved in those DB2 versions which do not support it?

1087

What is reorg and runstats in db2?

1228