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

what is the role of the cursor in db2?

1027

What is the use of predicate?

1010

What is null value in db2?

973

When do you specify the isolation level?

995

What is data manager?

1010

What is runstats and reorg in db2?

1261

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1030

What is dclgen in db2?

1100

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3545

What is db2 bind?

1035

How to execute stored procedures?

1080

What is bind in db2?

998

What is the difference between cursor and select statement?

1072

What is null in db2?

972

What is precompiler in db2?

984