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
11315 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 I have a view which is a join of two or more tables, can this view be updateable?

1139

Is db2 relational database?

979

what is db2 restart?

2158

Is db2 a programming language?

1048

How do I connect my db2 database to ibm?

1050

How to run db2 command in windows?

1193

What is blu acceleration in db2?

1069

Why cursor is used in db2?

1036

What is consistency token in db2?

1141

Define db2.

1113

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2065

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

1076

How many databases are there?

1052

What is copy pending and check pending in db2?

1004

Is the primary key a clustered index?

1149