(
SELECT
innerRec.Id,
innerRec.CreationDate,
innerRec.LastModified,
innerRec.AssetType,
innerRec.MasterFilename,
innerRec.GameName
FROM
[dbo].[Record] AS innerRec
WHERE
EXISTS
(
SELECT
*
FROM
[dbo].[RecordClassificationLink] AS innerLnk
WHERE
innerRec.Id = innerLnk.RecordId
)
) AS rec