SELECT ObjectId
    ,m.AccountID
    ,m.VLUID
    ,m.VehName
    ,m.MsgType
    ,m.EventTime
    ,m.FaultTime
    ,m.TotSigPkts
    ,m.TotFrmCnt
    ,m.FaultCnt
    ,m.FFrameCnt
INTO #SpecificFaults
FROM
    tblFaultMessage m
INNER JOIN
    (
        SELECT AccountId, VluId, FaultTime FROM tblFaultMessage (nolock)
        WHERE
            ReplicationCompletionDate IS NULL
        AND
            DequeuedDateTime IS NULL
        AND
            MsgType = 8
        GROUP BY
            AccountId, VluId, FaultTime
    ) AS FilteredEvents
ON
    m.AccountID = FilteredEvents.AccountID
AND
    m.VLUID = FilteredEvents.VLUID
AND
    m.FaultTime = FilteredEvents.FaultTime
AND m.accountid = 9999909 AND m.vluid = 6213
ORDER BY
    m.AccountID, m.VLUID, m.FaultTime, m.ObjectID


SELECT * FROM #SpecificFaults

SELECT * FROM tblFaultData (nolock) WHERE fdobjectid IN (
    SELECT objectid FROM #SpecificFaults
)

SELECT * FROM tblFaultFrame (nolock) WHERE fdobjectid IN (
    SELECT objectid FROM #SpecificFaults
)

DROP TABLE #SpecificFaults