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

How to find the number of rows in db2 tables?

1041

What is the syntax for seeing the columns and data types of a table in the db2 database?

1145

Which component is responsible for db2 startup and shutdown?

1016

When do you specify the isolation level?

1013

Comment whether the cursor is closed during commit or not.

1080

What is dbrm?

1084

How do I delete a table in database?

1004

What are foreign keys in db2?

1082

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1178

What is the role of schema in the db2 database?

1246

What is the latest version of ibm db2?

1252

What is the use of runstats in db2?

1086

What db2 400?

1143

What is dbrm in db2 database?

1091

Discuss about db2 bind?

1078