← Quiz: ER to Tables: all 15 questions
Quiz: ER to Tables · Question 15 of 15
Listing each course with its prerequisite's title needs the course table twice. How is that written?
Listing each course with its prerequisite's title needs the course table twice. How is that written?
- A.With UNION
- B.With a CROSS JOIN only
- C.Join course twice under different aliases, such as c and pre
- D.It cannot be done in SQL
Answer & explanation
Correct answer: Join course twice under different aliases, such as c and pre
Aliases let the same table play two roles, as in any self join.
Can you get the rest right without peeking?
Take the timed Quiz: ER to Tables quiz free. Pass it to earn XP and count towards your certificate.
Start the quiz →