i want to creat a view in which i can use DATEADD function used in SQL.
i have following tables
PROJECT ( PROJ_NUM, PROJ_NAME, PROF_NUM)
PROFESSOR ( PROF_NUM, PROF_FNAME, PROF_LNAME,
PROF_HIREDATE, JOB_CODE).
JOB (JOB_CODE, JOB_DESCRIPTION, JOB_CHG_HOUR)
ASSIGN (ASSIGN_NUM, ASSIGN_DATE, PROJ_NUM, PROF_NUM,
ASSIGN_HOURS)
now i want to create to views
1. (Name View: Views_One)
List columns name as Professor Number, Professor Full Name, Hire
Date and Job Description of those professors who are the part of
university faculty from last 6 months. using DATEADD function
and 2nd is
2. (Name View: Views_Two) Use Views_One as Nesting View
List columns name as Professor Full Name
1
, Project Name, Project
Assign Date and Assign Hours
Where Project Assign Date shouldn’t be older than 4 months and this
implies to those professors who are the part of university faculty from
last 6 months.
Using (View named: Views_One) , PROFESSOR, ASSIGN AND PROJECT
relations here.
PLz help me

still no reply .??????????????????????????//