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

What is the latest version of ibm db2?

1341

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9369

What is the difference between bind and rebind in db2?

1513

Which component is used to execute the sql statements?

1148

What is multi row fetch in db2?

1105

How do I copy a table in db2?

1059

What is dpf in db2?

1171

What is declare cursor?

1170

What types of tables are there in the db2 database?

1102

Outputs of explain are with matchcols = 0. What does this signify?

1113

Which command is used to connect to a database in DB2 ? Give the Syntax.

1153

What is difference between alias and synonym in db2?

1200

What is ibm db2 database?

1069

What is runstats utility in db2?

1072

How connect db2 database to datastage?

1291