Get Name from characters that died on Episode3 with its killer

You can join the characters table twice:

select, as killer
from films f
inner join deaths d on = d.id_film
inner join characters c on = d.id_character 
inner join characters k on = d.id_killer
where f.episode = 'Episode III'


  • Use standard joins! Implicit joins (with commas in the from clause) are legacy syntax from (literaly) decades ago, that should not be used in new code

  • Use single quotes for literal strings; in standard SQL, double quotes stand for identifiers (although MySQL makes things differently)

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top