SELECT q.[CertificationID], q.[QuestionID], q.[Text] AS [English], t.[Text] AS [Portuguese]
FROM [FMS].[Cert].[CertificationQuestion] AS q
LEFT JOIN [FMS].[Cert].[CertificationQuestionTranslation] AS t ON t.[QuestionID] = q.[QuestionID];