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
11079 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 cursor with hold option in db2?

1010

How to create db2 table in mainframe?

1103

How can you find out the # of rows updated after an update statement?

1051

What is the difference between cursor stability and repeatable read isolation levels?

1115

What is runstats utility in db2?

962

What is difference between alias and synonym in db2?

1068

What's The Percentage Free Space ?

1157

What is the use of db2?

1006

What does sqlcabc has?

994

Are views updateable?

1070

What is syscat in db2?

950

What is an instance in db2?

983

Define check constraint.

1026

What is dbrm? What it contains?

1110

How do I delete a table in db2?

1007