SQL uzklausa, pagal id kokia diena uzsiemimas

SELECT E.*, D.* FROM events E, days D WHERE E.TeacherID = '5' AND E.DayID = D.DayID

//mysql vykdyti
SELECT E.*, D.* FROM `events` E, `days` D WHERE E.TeacherID = '5' AND E.DayID = D.DayID

SELECT E.*, D.*, G.* FROM `events` E, `days` D, `groups` G WHERE E.TeacherID = '5' AND E.DayID = D.DayID AND E.GroupID = G.GroupID


//grupes mokiniai
SELECT P.id, P.name, UP.profile_id, UP.user_id, U.first_name, U.last_name FROM `profile` P, `user_profile` UP, `user` U  WHERE P.name = 'PS-0/2V' AND P.id = UP.profile_id AND UP.user_id = U.id