ðÒÉ×ÅÔ. îÁ×ÅÒÎÏ ÓÎÁÞÁÌÁ ÐÏÛÅÌ ÐÏ ÎÅÐÒÁ×ÉÌØÎÏÍÕ ÐÕÔÉ.
ÅÓÔØ ÔÁÂÌÉÃÁ Students (PK,fio...) É ÔÁÂÌÉÃÁ students_vs_groups(GROUP_ID,ACTUAL_DATE,STUDENT_ID) ÷ÒÏÄÅ × ÐÏÓÌÅÄÎÅÊ ÐÅÒÉÏÄÉÞÎÏÓÔØ ÐÒÉÓÕÔÓÔ×ÕÅÔ. âÙÌ ÓÔÕÄÅÎÔ ×ÞÅÒÁ × ÇÒÕÐÐÅ ÐÅÒ×ÏÊ (ÐÅÒ×ÁÑ,ÓÅÇÏÄÎÑ, ÓÔÕÄÅÎÔ). úÁ×ÔÒÁ ×Ï ×ÔÏÒÏÊ (×ÔÏÒÁÑ,ÓÅÇÏÄÎÑ, ÓÔÕÄÅÎÔ). îÏ ×ÏÔ ËÁË ÐÒÉ ÔÁËÏÍ ÒÁÓËÌÁÄÅ ÐÏÌÕÞÉÔØ ÓÐÉÓÏË ÓÔÕÄÅÎÔÏ× Ó ÎÏÍÅÒÁÍÉ ÇÒÕÐÐÕ ÎÁ ÔÅËÕÝÕÀ ÄÁÔÕ? Join Ó students_vs_groups ÂÅÓÐÏÌÅÚÅÎ, Ô.Ë. ÎÁÄÏ ÏÇÒÁÎÉÞÉ×ÁÔØ ÄÁÔÏÊ É select first 1. îÏ × join ÜÔÏ ÂÅÓÐÏÌÅÚÎÏ. á ÍÏÖÅÔ ×ÙÌÅÚÔÉ ÎÅÓËÏÌØËÏ ÓÔÒÏË ÎÁ ÓÔÕÄÅÎÔÁ. C Õ×ÁÖÅÎÉÅÍ