SELECT * FROM courses JOIN
(SELECT CLASS_ID FROM schedule WHERE S_ID = (SELECT S_ID FROM student_hold WHERE TAG_ID='99999')) A
WHERE A.CLASS_ID = courses.CLASS_ID;
由TAG_ID(逼逼卡)-->用"身分"查出此人修的課堂有哪些(此人的課表) 且列出詳細課程資訊等 上課時間 結束時間
SELECT B.CLASS_ID,B.CLASS_NAME FROM
(SELECT courses.* FROM courses JOIN
(SELECT CLASS_ID FROM schedule WHERE S_ID = (SELECT S_ID FROM student_hold WHERE TAG_ID='99999')) A
WHERE A.CLASS_ID = courses.CLASS_ID) B
WHERE B.START_TIME = '0910';
TAG_ID(RFID學生證)BB-->電腦比對"時間"與"身分"取得此人現在要上什麼課 列出 課程代碼&課程名稱
SELECT DEPARTMENT,S_ID,STUDENT_NAME,IS_SIGN,ENTER_TIME FROM sign JOIN
(SELECT CLASS_NAME FROM courses JOIN (SELECT CLASS_ID FROM open WHERE T_ID =
(SELECT T_ID FROM teacher_hold t WHERE TAG_ID = '88888')) A
WHERE courses.CLASS_ID = A.CLASS_ID AND courses.START_TIME = '0910') B
WHERE sign.CLASS_NAME = B.CLASS_NAME;
老師BB卡,得到現在時間(他開的課),並且得到現在修他課的已經到的學生
SELECT * FROM
(SELECT DEPARTMENT,STUDENT_NAME,s.S_ID FROM student JOIN
(SELECT S_ID FROM schedule JOIN
(SELECT courses.CLASS_ID FROM courses JOIN (SELECT CLASS_ID FROM open WHERE T_ID =
(SELECT T_ID FROM teacher_hold t WHERE TAG_ID = '88888')) A
WHERE courses.CLASS_ID = A.CLASS_ID AND courses.START_TIME = '0910') B
WHERE B.CLASS_ID = schedule.CLASS_ID) s
WHERE student.S_ID = s.S_ID) q
WHERE S_ID NOT IN
(SELECT S_ID FROM sign JOIN
(SELECT CLASS_NAME FROM courses JOIN (SELECT CLASS_ID FROM open WHERE T_ID =
(SELECT T_ID FROM teacher_hold t WHERE TAG_ID = '88888')) A
WHERE courses.CLASS_ID = A.CLASS_ID AND courses.START_TIME = '0910') B
WHERE sign.CLASS_NAME = B.CLASS_NAME);
未到名單
SELECT s.S_ID,STUDENT_NAME FROM student JOIN
(SELECT S_ID FROM schedule JOIN
(SELECT courses.CLASS_ID FROM courses JOIN (SELECT CLASS_ID FROM open WHERE T_ID =
(SELECT T_ID FROM teacher_hold t WHERE TAG_ID = '88888')) A
WHERE courses.CLASS_ID = A.CLASS_ID AND courses.START_TIME = '0910') B
WHERE B.CLASS_ID = schedule.CLASS_ID) s
WHERE student.S_ID = s.S_ID;
修課名單
