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

How would you find out the total number of rows in a db2 table?

1095

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2414

What is the information associated with sysibm.syslinks table?

1171

What are the prerogatives?

1129

How do I copy a table in db2?

1059

What is package in db2 mainframe?

1039

What are packages in db2?

1076

How would the varchar column remarks defined?

1135

How to take backup of table in db2?

1123

How do I add a column to a table in db2?

1160

How does db2 sample database connect?

1089

What is ibm db2 used for?

1133

What is temporal table in db2?

1101

How do I add a column to an existing table in db2?

1083

What is performance tuning db2?

1112