Answer to Question #238085 in Databases | SQL | Oracle | MS Access for Owen

Question

1.2 SELECT and RETURN all students with qualification HCIT from relations STUDENTS X BOOKS.

Answer 1

Cross Join

create table STUDENTS_BOOKS as SELECT STUDENTS.Student_ID,STUDENTS.Student_Name, STUDENTS.qualification, BOOKS.Book_ID, BOOKS.Title, BOOKS.Copy_right 
 FROM BOOKS,STUDENTS;

SELECT Student_Name FROM STUDENTS_BOOKS where Qualification = 'HCIT';