Reply to Re: SQL Join

Your name:

Reply:


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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация