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

How many databases can be created inside an instance in db2 ?

1045

What does db2 mean?

1028

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

1040

Explain the benefits you can get from mainframe connect?

981

What is a db2 table?

1027

What does a deadlock mean in DB2?

1180

What is dclgen in db2?

1156

Why do chiropractors use drop table?

1115

What is precompiler in db2?

1027

What is a system catalog table in db2?

1198

How do I optimize a query in db2?

1106

What is dpf in db2?

1118

What is concurrency?

1243

What is buffer pool in the db2 database?

1117

How would the varchar column remarks defined?

1095