USE DoctorWho

​

SELECT *

FROM tblAuthor INNER JOIN

tblEpisode ON tblAuthor.AuthorId = tblEpisode.AuthorId INNER JOIN

tblEpisodeEnemy ON tblEpisode.EpisodeId = tblEpisodeEnemy.EnemyId INNER JOIN

tblEnemy ON tblEpisodeEnemy.EnemyId = tblEnemy.EnemyId

WHERE EnemyName like '%Daleks%'