find a match by comparing two fields from two tables

Two entities: Teacher & student. I want to match the class taken by the student with the class which the teacher has been assigned. For example: Student has 6 classess: hist-1111-315-01, hist-2222-315-01, hist-3333-315-01, hist-4444-315-01, hist-5555-315-01 and so on The number assigned to each class is unique. THe teacher has been assigned calssess:hist-2222-315-01, pols-2898-315-01, hist-2898-315-01, hist-2898-315-01 ,hist-2898-315-01 Thus you see that the teacher and the student are matching for class hist-2222-315-01. So this is the wanetd output. Thus we will have two tables each for students and for teachers details.( there are many teachers and many stuidents and thus we need a program to find the match) ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased. ## Platform Windows,