Internal error on FMS

[Former Member]

Hi All,

The query mentioned below throws internal error.

Can someone help to fix this query?

The fms is to be triggered at a udf on header level.

SELECT T0.[City] FROM OWHS T0  left JOIN RDR1 T1 ON T0.WhsCode = T1.WhsCode WHERE T0.[WhsCode] = $[RDR1.Whscode]

Thanks,

Joseph

[kothandaraman_nagarajan · Accepted solution]

Hi Joseph,

Try this:

SELECT distinct T0.[City] FROM OWHS T0  left JOIN RDR1 T1 ON T0.WhsCode = T1.WhsCode WHERE T0.[WhsCode] = $[$-38.24.0]

'

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Thanks Nagarajan!!

I forgot to use this one

Thanks,

Joseph

Happy New Year!!!

[kothandaraman_nagarajan · Accepted solution]

Hi,

Happy new year!!!.

Thanks & Regards,

Nagarajan