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

What is db2 stogroup?

1223

What os does db2 run on?

1049

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

1239

Is it possible using max on a char column?

1195

What type of database is db2?

1019

How do I import a csv file into db2?

1041

What is cloudant database?

1158

What is a bind card?

1281

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4372

what is the sqlcode -501

13309

What is the advantage in De-normalizing tables in DB2?

1237

What is collection in db2 bind?

1063

How many databases are there?

1112

How to take backup of table in db2?

1123

what is the responsibility of the construction superintendent

2211