USE maBD
go

SELECT TOP 2
PromoType.[Id] AS Id,
PromoType.[THEME] AS Theme,
PromoName.LANG_ID AS LANGUAGE,
PromoName.FROM_DATE AS FromDate,
PromoName.TO_DATE AS...