select e.name,e.deptname,d.doj from emp_table e,dept

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

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

Answer Posted / harsha

select e.name,e.deptname,d.doj from emp_table e,dept_table d
where e.deptno=d.deptno and doj between '01-jan-2007' and
'01-jan-2008'

Is This Answer Correct ?

5 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is db2 optimizer?

1202

What is runstats db2?

977

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1124

What os does db2 run on?

940

What is a trigger in the db2 database?

1035

Which is faster delete or truncate?

1085

What is copy pending status in db2?

1085

What is access path in db2?

943

What is the difference between db2 and oracle?

1082

Explain various types of locks in db2?

1103

What types of tables are there in the db2 database?

1024

Mention the definition of cobol in varchar field.

1204

What is db2 bind process?

1200

What are the contents of a dclmgen?

1088

What are catalog tables in db2?

1010