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
11085 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 data manager?

995

What is null indicator in cobol db2?

994

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2340

what are bind concepts in db2 cobol?

1036

What is bind package and plan in db2?

1006

What is ibm db2 database?

953

Give a brief description of db2 isolation levels?

1014

How to create db2 table in mainframe?

1105

What are types of indexes?

1001

What is nvl in db2?

1041

what is a corelated subquerry?

1065

Which isolation level provides highest data integrity?

1043

List some fields from sqlca?

1004

How can deadlocks be resolved?

889

What is the picture clause of null indicator variable?

1083