select name.deptname.doj from emp_table innerjoin dept_table on emp

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 / s

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

Answer Posted / s

select name.deptname.doj from emp_table innerjoin dept_table
on emp_table.deptno = dept_table.deptno

Is This Answer Correct ?

3 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain how can you do the explain of a dynamic sql statement?

1082

How do we specify index to include or not during bind process.

2088

How to restart a DB2 program?

1846

Can we delete records from view?

934

What is runstats utility in db2?

987

What is query_cache_limit?

941

What is syscat in db2?

966

Which isolation level provides highest data integrity?

1070

What is db2 bind process?

1202

List out the buffer pools in db2

1043

What is copy pending status in db2?

1086

What is cobol db2?

955

What is a db2 schema?

1198

What is table space in db2?

977

Is ibm db2 open source?

1039