Code:
SELECT CommTypes.Description
FROM CommTypes LEFT JOIN
(SELECT *
FROM IntroducerBasis
WHERE IntroducerBasis.IntroducerCode ='AG'
AND IntroducerBasis.BasisNumber=1)
AS Intro
ON CommTypes.ID = Intro.CommTypeID;