Our training courses

Other training resources

Our training venues

Why we are different

Details for grao

grao has participated in the following threads:

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

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%'

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.

End of small page here
Please be aware that our website uses cookies!
I'm OK with this Tell me more ...