September 20, 2006

Today, we worked with queries. We joined the Employer table and Position table. Our query filtered out other information that didnt not involved employers ID, start date, end date and their avaliable position. We also worked with relationships. We added a relationship between the Employer table and the Position table. The relationship between them was the Employer ID. It was a one to many relationship, Employer being the one and Position being the many.