Our training courses

Other training resources

Our training venues

Why we are different

Details for LACubico

LACubico 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.

USE DoctorWho
select a.AuthorId,a.AuthorName,
b.Title,b.episodetype,
c.EnemyId, d.EnemyName
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'

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 ...