Hi All,

I got error in advance query, but i dont know where location in this error

i use Service Studio P11

this is my sql query:

SELECT {TABLE1}.[FIELD1], COUNT({TABLE2}.[FIELD1]), ROUND(

    (IF(SUM({TABLE3}.[FIELD1]) IS NULL, 0, SUM({TABLE3}.[FIELD1])) + IF(SUM({TABLE4}.[FIELD1]) IS NULL, 0, SUM({TABLE4}.[FIELD1]))

    )/1000000

    , 2

    ),0,0

FROM {TABLE2} 

    LEFT JOIN {TABLE5} ON {TABLE2}.[Id] = {TABLE5}.[Id]

    INNER JOIN {TABLE6} on ({TABLE6}.[Id] = {TABLE2}.[FIELD2])

    LEFT JOIN {TABLE1} ON {TABLE5}.[FIELD1] = {TABLE1}.[Id]

    INNER JOIN {TABLE7} ON {TABLE2}.[Id] = {TABLE7}.[FIELD1]

    INNER JOIN {TABLE8} ON {TABLE7}.[Id] = {TABLE8}.[Id]

    LEFT JOIN {TABLE3} ON {TABLE3}.[Id] = {TABLE2}.[Id]

    LEFT JOIN {TABLE4} on {TABLE2}.[FIELD1] = {TABLE4}.[FIELD1]

WHERE

    ({TABLE8}.[FIELD1] = @param)

    AND {TABLE6}.[Name] = 'String'

GROUP BY {TABLE1}.[FIELD1]

UNION ALL

SELECT {TABLE1}.[FIELD1], COUNT({TABLE2}.[FIELD1]), ROUND(

    (

        IF(SUM({TABLE3}.[FIELD1]) IS NULL, 0, SUM({TABLE3}.[FIELD1]))

        + IF(SUM({TABLE4}.[FIELD1]) IS NULL, 0, SUM({TABLE4}.[FIELD1]))

    )/1000000

    , 2

),0,0

FROM {TABLE2} 

    LEFT JOIN {TABLE5} ON {TABLE2}.[Id] = {TABLE5}.[Id]

    INNER JOIN {TABLE6} on ({TABLE6}.[Id] = {TABLE2}.[FIELD2])

    LEFT JOIN {TABLE1} ON {TABLE5}.[FIELD1] = {TABLE1}.[Id]

    INNER JOIN {TABLE7} ON {TABLE2}.[Id] = {TABLE7}.[FIELD1]

    INNER JOIN {TABLE9} ON {TABLE7}.[Id] = {TABLE9}.[Id]

    LEFT JOIN {TABLE3} ON {TABLE3}.[Id] = {TABLE2}.[Id]

    LEFT JOIN {TABLE4} on {TABLE2}.[FIELD1] = {TABLE4}.[FIELD1]

WHERE

    ({TABLE9}.[FIELD1] = @Param)

    AND {TABLE6}.[Name] = 'String'

GROUP BY {TABLE1}.[FIELD1]

ORDER BY FIELD1

And i attach for error information

Hope you guys know what i mean

Thank you All.