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
11165 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 clone table?

1018

Who uses db2?

1004

What is the use of db2 optimizer?

1076

What does db2 stand for?

976

Is db2 a mainframe database?

967

In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1010

What is cobol db2?

957

What is the difference between using bind () and rebind () methods of naming class?

1359

How do you select a row using indexes in db2?

1088

What are the contents of a dclmgen?

1091

What is the purpose of using commit?

1053

How can you quickly find out the # of rows updated after an update statement?

1011

What is dbrm? When it will be created?

993

Is db2 a programming language?

1006

If I have a view which is a join of two or more tables, can this view be updateable?

1104