this is for holding javascript data
H.S.Bhathiya(110059X) edited section_Proposed_Solution_We_propose__.tex
about 8 years ago
Commit id: 49919fe29653e920a0d7315caafc9aec5d6fa517
deletions | additions
diff --git a/section_Proposed_Solution_We_propose__.tex b/section_Proposed_Solution_We_propose__.tex
index 12be861..9c26ee6 100644
--- a/section_Proposed_Solution_We_propose__.tex
+++ b/section_Proposed_Solution_We_propose__.tex
...
\end{verbatim}
\end{document}
\begin{document}
\begin{verbatim}
WITH
t1 as (SELECT /*+ no_merge */ INSTRUCTOR.ID as Instructor_ID, COURSE.COURSE_ID, COURSE.COURSE_ID as T1_ID
FROM INSTRUCTOR ,TEACHES,COURSE
WHERE TEACHES.COURSE_ID=COURSE.COURSE_ID),
t2 as (SELECT /*+ no_merge */ STUDENT.ID as Student_ID, student.name as Student_Name, COURSE.COURSE_ID, COURSE.COURSE_ID as T2_ID, COURSE.TITLE as TITLE
FROM COURSE, TAKES, STUDENT
WHERE TAKES.COURSE_ID = COURSE.COURSE_ID AND STUDENT.ID = TAKES.ID)
SELECT t2.Student_ID, t2.Student_Name, t1.Instructor_ID, t2.TITLE
FROM t1, t2
where t1.T1_ID = t2.T2_ID;
\end{verbatim}
\end{document}