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

Explain in detail about buffer manager and its functionalities?

1028

What is a bind in db2?

1007

Explain the function done by data manager?

1240

What are the different types of base tables?

1053

What is syscat in db2?

966

What r the comman abends in db2, jcl and cobol???????

2223

What is the maximum size of a char data type in db2?

978

When reorg is used?

1088

What is universal database?

1042

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

1246

What is host variable in db2 cobol?

1044

How to check table size in db2 sap?

994

What is db2?

1144

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1030

What is package in db2 mainframe?

942