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

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1976

What is the physical storage length of timestamp data type?

1027

How to compare data between two tables in db2?

1033

What is a Foreign Key?

1040

Define check constraint.

1028

What is page size in db2?

906

What is null value in db2?

953

How can record locking be achieved in those DB2 versions which do not support it?

1021

What is the cobol picture clause of the db2 data types date, time, timestamp?

1012

What is the use of with ur in db2?

1004

what is the role of the cursor in db2?

1002

What is deadlock in db2?

1021

What is a dbrm in db2?

971

What is the latest version of ibm db2?

1203

What are db2 tables?

1053