Browse 545 attributed reviews, viewable separately for our classroom and online training

Details for grao

grao has participated in the following threads:

Added by grao on 05 Nov 2017 at 18:42

So is this the code?

use doctorwho

Select authorname

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?

use doctorwho

Select companionname
from tblCompanion as c
left outer join tblEpisodeCompanion as e
on c.CompanionId=e.EpisodeCompanionId
where e.EpisodeCompanionId =null