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

How do I create a view in db2?

1029

What is schema in db2?

1026

What is cascading rollback?

1220

What is load utility in db2?

1184

How to check last update on table in db2?

1064

what is the sqlcode -501

13170

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1095

Are view updateable?

1051

How can you count the number of rows from a table tab?

1094

What is difference between isnull and coalesce?

1060

Why select is not preferred in embedded sql programs?

1307

What is nvl in db2?

1104

What is data manager?

1056

What is buffer pool and list some of them?

1043

Is the primary key a clustered index?

1152