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
11325 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 are foreign keys in db2?

1109

Which component is used to execute the sql statements?

1103

How connect db2 database to datastage?

1247

How to access db2 tables in mainframe?

1057

What is an instance in db2?

1039

What is reorg?

1164

What is netezza database?

1032

What is deadlock in db2?

1074

What is a db2 schema?

1239

How do we specify index to include or not during bind process.

2131

Explain correlated sub-queries.

1036

Where can you declare a cursor in a cobol-db2 program?

1078

How many databases are there?

1060

Which isolation level provides maximum concurrency?

1156

What is universal database?

1074