Select HTAR_AcomodacionId, HOTA_Acomodacion, HTAR_CategoriaId,
        Categoria, HTAR_PrecioTar from HotTarifas,
        (Select HotCategoriasId, CAT_Cat1 as Categoria from HotCategorias
            where HotCategoriasId
        in ( SELECT HTAR_CategoriaId FROM HotTarifas
                  Where HTAR_HotelID = 2
                  and HTAR_AcomodacionId = 3))
           as NomCategoria, HotAcomodaciones
           Where HTAR_CategoriaId
        in (SELECT HTAR_CategoriaId FROM Hot
          Where HTAR_HotelID = 2
           and HTAR_AcomodacionId = 3)
           and HotCategoriasId = HTAR_CategoriaId
           and HotAcomodacionesId = HTAR_AcomodacionId