SQL Statement doesn't work

[#1]

Hi to All!!!

i have one sql statement but it doesnt work on Qlikview, but it does in SQL:

Transac:

LOAD

IdentifEspacio,

HoraInicio_EC,

HoraFin_EC,

PautaId,

AnoMes,

HoraInicio_OC,

HoraFin_OC,

CantSalidas,

DuracionTot,

VigDesde_CV,

VigHasta_CV,

Frecuencia_CV,

Horario,

Version

;

SQL SELECT EspacioCont.IdentifEspacio, EspacioCont.HoraInicio as HoraInicio_EC, EspacioCont.HoraFin as HoraFin_EC,

OrdenadoCab.PautaId, OrdenadoCab.AnoMes, OrdenadoCab.HoraInicio as HoraInicio_OC, OrdenadoCab.HoraFin as HoraFin_OC, OrdenadoCab.CantSalidas, OrdenadoCab.DuracionTot,

CostoVersion.VigDesde as VigDesde_CV, CostoVersion.VigHasta as VigHasta_CV, CostoVersion.Frecuencia as Frecuencia_CV, CostoVersion.Horario, CostoVersion.Version

FROM

  Publicidad.dbo.EspacioCont ,

  Publicidad.dbo.OrdenadoCab ,

  Publicidad.dbo.CostoVersion

where

  EspacioCont.IdentifEspacio = 'AMER-INTR-PROG' and

  OrdenadoCab.IdentifEspacio = EspacioCont.IdentifEspacio and

  CostoVersion.IdentifEspacio = OrdenadoCab.IdentifEspacio and

  CostoVersion.Version = (select max(CostoVersion.version)

                    from Publicidad.dbo.CostoVersion

                    where CostoVersion.IdentifEspacio = EspacioCont.IdentifEspacio

                    group by CostoVersion.IdentifEspacio)

order by

  EspacioCont.IdentifEspacio;

Why doesnt return me any row???  In Sql the query HAVE 28 rows...

Any Idea?

Thanks to all!

[#2]

I have tryied with OLEDB and it doesnt return me any data...

Thanks Michael