Details for LACubicoLACubico has participated in the following threads:
Added by LACubico on 25 Sep 2018 at 15:35
Use inner joins to link four tables to show Dr Who enemies by author.
from tblAuthor as a
inner join tblEpisode as b on
a.AuthorId = b.AuthorId
inner join tblEpisodeEnemy as c on
c.EpisodeId = b.EpisodeId
inner join tblEnemy as d on
d.EnemyId = c.EnemyId
where d.EnemyName = 'Daleks'