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

Why db2 is called db2?

1051

Is the primary key a clustered index?

1152

Can we delete records from view?

972

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2860

What is plan in cobol db2?

1144

What is the physical storage length of date data type?

1258

What type of database is db2?

974

What is nvl in db2?

1104

What is concurrency?

1241

What is a storage group (stogroup)?

1249

Explain about open switch business continuity software?

1140

What is package in cobol db2?

1121

What is check constraint. Explain with example.

1114

Name the lockable units in DB2?

1133

Can one database have multiple instances?

1058