|
Posted by germanshorthairpointer@gmail.com on 06/24/06 01:59
Thanks Erland!
> Joined to what?
I would like YR_CDE and TRM_CDE added to my view (if a respective
ID_NUM is in the FACULTY table)
> I'm afraid that I don't understand. If ID_NUM is a primary key how could
> then JOB_TIME then determine which YR_CDE and TRM_CDE to join? Is it the
> case that the primary key is (ID_NUM, JOB_TIME)?
ID_NUM is the primary key in the FACULTY table. However, each ID_NUM
may have many different YR_CDE and TRM_CDE in the FACULTY table. The
row with the latest JOB_TIME for a respective ID_NUM contains the
latest Year (YR_CDE) and Term code (TRM_CDE) that a faculty member has
taught. Does that help any? Thanks for your help!!!
Navigation:
[Reply to this message]
|