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
11244 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

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2369

What parameters are used to control the free space in DB2?

1039

Explain in brief how does db2 determine what lock-size to use?

1022

Explain what are the various isolation levels possible?

1027

What is the role of schema in the db2 database?

1246

Can we insert update delete in view?

948

What is load utility in db2?

1166

What types of tables are there in the db2 database?

1036

Explain correlated sub-queries.

1010

What does reorg do in db2?

1018

What is null indicator in cobol db2?

1041

Name the lockable units in DB2?

1110

Explain in detail about buffer manager and its functionalities?

1052

How do I create a view in db2?

1004

What is meant by union and union all?

986