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

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

Answer Posted / ramesh

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 ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2331

What is the maximum number of columns in a db2 table?

1285

What is the syntax for creating a table in the db2 database?

1109

What is dclgen (declaration generator)?

1060

Which command is used to remove all rows from a table?

1112

How to create backup table in db2?

1094

Can there be more than one cursor open for any program?

1169

What is db2 optimizer?

1240

What is drop table?

1012

What is a Foreign Key?

1100

What is the physical storage length of the data types date, time, and timestamp?

1091

What is buffer pool in the db2 database?

1109

List down the types of triggers in the db2 database?

1033

What is copy pending status in db2?

1127

Highlight all the advantages that are attached to a package.

1119