SHARE
TWEET

Untitled

a guest Jun 19th, 2019 66 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Insert into Mark (id_student,mark,date,id_discteacher)
  2. Select student.id_student,'10','2019-05-09',id_discteacher from discipline_teacher
  3. JOIN discipline using(id_discipline)
  4. join teacher using(id_teacher)
  5. join group on class.id_group = discipline_teacher.group  
  6. join student on student.group = group.id_group
  7. where EXISTS (select * from discipline_teacher
  8.              join group on discipline_teacher.group = group.id_group
  9.               join student on student.group = group.id_group
  10.               JOIN discipline using(id_discipline)
  11.               join teacher using(id_teacher)
  12.               where discipline.title ='math' and teacher.id_teacher=1 and group.title ='2' and group.kurs ='А')
  13.               and discipline.title ='math' and teacher.id_teacher=1 and group.title ='2' and group.kurs ='А' and student.name = 'Anna' and student.last_name ='Makeeva';
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top