Select a.Name,a.DeptName,b.doj From Emp_Table as a,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 / arul

6 Answers
11525 Views
Perot Systems, I also Faced
E-Mail Answers

Answer Posted / arul

Select a.Name,a.DeptName,b.doj From Emp_Table as
a,Dept_Table as b Where a.Deptno=b.deptno and b.doj
between '01-jan-2007' And '01-jan-2008'

Is This Answer Correct ?

3 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is consistency token in db2?

1196

What does db2 plan contain?

1090

What is the role of union all and union

1190

What is copy pending and check pending in db2?

1046

When reorg is used?

1184

Explain dclgen.

1274

what is the role of the cursor in db2?

1115

How do I import a csv file into db2?

1041

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2224

What is explain in db2?

1080

Explain correlated sub-queries.

1096

What are bind parameters in db2?

1097

What is access path in db2?

1044

How can we read records for specific member in CL? AND rpg?

760

What is buffer pool and list some of them?

1098