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

Where do you specify them?

1289

How do you stop a db2 database in linux?

1019

How to find schema of a table in db2?

1018

What is check constraint. Explain with example.

1113

Explain package in db2 and its advantages?

1219

What is package in db2 mainframe?

990

How to get the ddl of a table in db2?

1132

How to resolve deadlock issue

20145

How can the duplicate values be eliminated from db2 select?

1106

Explain about rct in db2?

1113

What do you mean by between and in? Is between inclusive of specified range values?

1092

List out the buffer pools in db2

1077

Mention the definition of cobol in varchar field.

1250

What are types of indexes?

1079

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

1104