Try this if wrong let me know... SELECT A.NAME ,A.DEPTNAME

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 / nimsatprasad

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

Answer Posted / nimsatprasad

Try this if wrong let me know...

SELECT A.NAME
,A.DEPTNAME
,B.DOJ
FROM EMP_TABLE A
,DEPT_TABLE.EMP_TABLE B
WHERE A.DEPTNO = B.DEPTNO
AND B.DOJ BETWEEN '01-01-2007' AND '01-01-2008'
;

Is This Answer Correct ?

14 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of with ur in db2?

1033

What is a system catalog table in db2?

1163

What is a db2 tablespace?

1044

How to get the ddl of a table in db2?

1116

What is dclgen (declaration generator)?

1035

What are the prerogatives?

1065

What is the usage of open cursor command?

1082

What is alias in db2?

1027

How to check sequence on a table in db2?

1043

Explain dclgen.

1180

How do I import data from excel to db2?

1052

What is the difference between plan and package in db2?

1095

What is release/acquire in bind?

1091

What is db2 purescale?

979

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2903