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
11319 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 db2 look?

1026

What type of database is db2?

971

Can you tell me how can you find out the # of rows updated after an update statement?

1101

How to check last update on table in db2?

1060

What are concurrency issues?

1097

When reorg is used?

1129

How to restart a DB2 program?

1902

Mention the different locking levels that are available in db2.

1138

Is db2 a database?

979

Mention the downsides of page level lock.

1163

What kind of database is db2?

1038

What is the maximum size of varchar data type in db2?

1137

How to test SQL -911 error while developing COB-DB2 program

7575

What is the use of value function?

1151

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

1401