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
11522 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 alias in db2?

1112

How to get the ddl of a table in db2?

1170

What happens in bind step in a db2 program?

1012

What is the meaning concurrency in the db2 database?

1170

What is table space in db2?

1072

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4372

What types of tables are there in the db2 database?

1101

What is meant by union and union all?

1055

What is a collection in db2?

1095

Why do we need reorg in db2?

1047

When reorg is used?

1184

What is isolation level in db2?

1070

What does db2 mean?

1086

What is drop table?

1071

What is data manager?

1105