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

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

Answer Posted / ramesh

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 ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Which isolation level provides highest data integrity?

1190

What is the difference between oracle and db2?

1175

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

1248

Is ibm db2 open source?

1132

What is the purpose of rollback and commit?

1291

What is plan in cobol db2?

1208

Explain various types of locks in db2?

1210

What is rct?

1296

i want to maintain uniqueness on pdf without make lf??????????

2209

What is the role of schema in the db2 database?

1366

What is db2 bind process?

1292

What is a db2 cursor?

1112

What are the two types of logging in the db2 database? Explain them.

1128

How many databases are there?

1112

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1134