I created this Dynamic list

IPredicateExpression WHERE = new PredicateExpression(); WHERE.Add( VisitaFields.Idpromoter == Prom.Idpromoter);

        WHERE.AddWithAnd(VisitaFields.Datavisita >= dataDa.Value);
        WHERE.AddWithAnd(VisitaFields.Datavisita <= dataA.Value);
        visiteRivenditeTypedList1.Fill(0, SORT, false, WHERE);

        ResultsetFields fields = new ResultsetFields(4);
        fields.DefineField(VisitaFields.Qtapremiomat, 0, "QTA1", "Visita", AggregateFunction.Sum);
        fields.DefineField(VisitaFields.Qtapremioomg, 1, "QTA2", "Visita", AggregateFunction.Sum);
        fields.DefineField(VisitaFields.Qtapremioord, 2, "QTA3", "Visita", AggregateFunction.Sum);
        fields.DefineField(VisitaFields.Pacchettiregalati, 3, "FREE", "Visita", AggregateFunction.Sum);
        DataTable dynamicList = new DataTable();
        YSTGC.DAU.DaoClasses.TypedListDAO  dao = new YSTGC.DAU.DaoClasses.TypedListDAO();

        dao.GetMultiAsDataTable(fields, dynamicList, 0, null, WHERE,null, true, null, null, 0, 0);

The query is :

Query: SELECT SUM([Visita].[QTAPREMIOMAT]) AS [QTA1], SUM([Visita].[QTAPREMIOOMG]) AS [QTA2], SUM([Visita].[QTAPREMIOORD]) AS [QTA3], SUM([Visita].[PACCHETTIREGALATI]) AS [FREE] FROM [YSTGC].[dbo].[VISITA] AS [Visita] WHERE ( ( [YSTGC].[dbo].[VISITA].[IDPROMOTER] = @Idpromoter1 AND [YSTGC].[dbo].[VISITA].[DATAVISITA] >= @Datavisita2 AND [YSTGC].[dbo].[VISITA].[DATAVISITA] <= @Datavisita3))

Parameter: @Idpromoter1 : Int32. Length: 0. Precision: 10. Scale: 0. Direction: Input. Value: 12.
Parameter: @Datavisita2 : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 01/01/2008 0.00.00.
Parameter: @Datavisita3 : DateTime. Length: 0. Precision: 0. Scale: 0. Direction: Input. Value: 26/06/2008 18.11.33.

As you see the fields are without [YSTGC].[dbo] and this makes SqlServer raise an error 4104.

What i'm missing?

Thanks

The solution i found by myself was clear to the alias for the entity.

Thx