select tblExternalPages.*, 'notloggedin' as strLocalUserName from tblExternalPages inner join tblProgrammes on (tblProgrammes.pkguidId = tblExternalPages.guidProgrammeID) where tblExternalPages.strAlias = 'NissanHeartBeatRegistration' and tblProgrammes.guidTemplateID = ''