Details for graograo has participated in the following threads:
Added by grao on 05 Nov 2017 at 18:42
So is this the code?
from tblauthor as a
inner join tblepisode as epi
on a.authorid = epi.authorid
inner join tblepisodeenemy as ene
on epi.episodeid = ene.episodeenemyid
inner join tblenemy as enemy
on enemy.enemyid = ene.episodeenemyid
where title like '%Daleks%'
Added by grao on 07 Nov 2017 at 01:34
I am not getting any results. Is this the right code?
from tblCompanion as c
left outer join tblEpisodeCompanion as e
where e.EpisodeCompanionId =null