When adding a CAST in a cross connection query it results in the following error message:
"Cross Query Database Error: You have an error in your SQL syntax; check the manual that corresponds to your Cross Query server version for the right syntax to use near 'INT)' at line 24". SQL: SELECT DISTINCT ... FROM (((`... INNER JOIN `X-XXXX.XXXXX (XXXXX), XXXXX`.XXXXX.XXX_XX_XXXXXX XXX_XX_XXXXXX ON (XXX_XX_XXXXXX.XXXXXX = cast (XXXXX_XXXXXX_XXXX.XXXXXX_XXXXX as int))) ..."
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.