H.S.Bhathiya(110059X) edited section_Proposed_Solution_We_propose__.tex  about 8 years ago

Commit id: be4eb3e5163f088d1203af4d4f9c1957eb837aaa

deletions | additions      

       

\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 t1, t2   where t1.T1_ID = t2.T2_ID;  \end{verbatim}  \end{document}