1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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 / amlan roy

Answer Posted / amlan roy

Select...........
from....
........
where DEPT_TABLE.DEPNO = EMP_TABLE.DEPNO.
AND DOJ between '01/01/2007' and '01/01/2008'

Is This Answer Correct ?    11 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is schema in db2?

577

What is consistency token in db2?

646

What are the contents of dclgen?

661

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

723

What is data manager?

612




What is catalog database in db2?

646

What is isolation level in db2?

580

How to resolve deadlock issue

17994

What are the contents of a dclmgen?

630

Explain the contention situations caused by locks?

596

What is db2 optimizer?

773

How do I import data from excel to db2?

617

What is the difference between db2 and oracle?

683

What is syscat in db2?

582

How to find primary key of a table in db2?

617