no set of rows was returned to the table, query, or procedure

 

query report is :

 

SELECT
    DO30_DOCCORPO."DO30_CODART_MG66",
    DO30_DOCCORPO."DO30_DESCART",
    DO30_DOCCORPO."DO30_COLLI",
    DO11_DOCTESTATA."DO11_NUMDOC",
    DO11_DOCTESTATA."DO11_DATADOC",
    CG16_ANAGGEN."CG16_RAGSOANAG",
     (   select  top 1 IE29_TRASCODIFVAL.IE29_VALESTERNO from IE29_TRASCODIFVAL
where IE29_TRASCODIFVAL.IE29_CODTRASC_IE28 = 'VBS_MG66_001'
and IE29_TRASCODIFVAL.IE29_VALINTERNO = isnull(
    (select
        isnull(MG66_ANAGRART.MG66_GPH_CASSA,0) from MG66_ANAGRART
    where MG66_ANAGRART.MG66_CODART = DO30_DOCCORPO."DO30_CODART_MG66"), 0)
)
FROM
    ((dbo.DO30_DOCCORPO DO30_DOCCORPO INNER JOIN dbo.DO11_DOCTESTATA DO11_DOCTESTATA ON
        DO30_DOCCORPO."DO30_DITTA_CG18" = DO11_DOCTESTATA."DO11_DITTA_CG18" AND
        DO30_DOCCORPO."DO30_NUMREG_CO99" = DO11_DOCTESTATA."DO11_NUMREG_CO99")
    INNER JOIN dbo.CG44_CLIFOR CG44_CLIFOR ON
        DO11_DOCTESTATA."DO11_DITTA_CG18" = CG44_CLIFOR."CG44_DITTA_CG18" AND
        DO11_DOCTESTATA."DO11_TIPOCF_CG44" = CG44_CLIFOR."CG44_TIPOCF" AND
        DO11_DOCTESTATA."DO11_CLIFOR_CG44" = CG44_CLIFOR."CG44_CLIFOR")
    INNER JOIN dbo.CG16_ANAGGEN CG16_ANAGGEN ON
        CG44_CLIFOR."CG44_CODICE_CG16" = CG16_ANAGGEN."CG16_CODICE"
WHERE
    DO11_DOCTESTATA."DO11_DATADOC" = {d '2009-01-10'}
ORDER BY
     (   select  top 1 IE29_TRASCODIFVAL.IE29_VALESTERNO from IE29_TRASCODIFVAL
where IE29_TRASCODIFVAL.IE29_CODTRASC_IE28 = 'VBS_MG66_001'
and IE29_TRASCODIFVAL.IE29_VALINTERNO = isnull(
    (select
        isnull(MG66_ANAGRART.MG66_GPH_CASSA,0) from MG66_ANAGRART
    where MG66_ANAGRART.MG66_CODART = DO30_DOCCORPO."DO30_CODART_MG66"), 0)
) ASC

 

 

grazie