Select TOP in relazione con altra tabella

SELECT TOP 300 * FROM TabellaA a JOIN TabellaB b ON a.campoID=b.campoID

WITH CTE_FileTest_CNC AS
(
    SELECT TOP(300) IDCarico, IDMacchina, IDProgramma
    FROM dbo.FileTest_CNC
)
SELECT CTE.*, FR.*
FROM CTE_FileTest_CNC AS CTE
JOIN FileRighe_CNC AS FR
ON CTE.IDCarico = FR.IDCarico
AND CTE.IDMacchina = FR.IDMacchina
AND CTE.IDProgramma = FR.IDProgramma;