WORKAROUND:
The syntax for a cross-connection is very specific. It includes the full connection and database and table, often in tick marks like below. Also the cross-connection engine may prefer ANSI SQL joins (INNER join on....). The SQL would look something like below.
Please have the ‘Cross-Connection Query Builder’ build the query for you instead of using the ‘Cross-Connection Editor’.
SELECT ADDRESS.*
, REGION.REGION_NAME
FROM
`alvdpeabody2.prod.quest.corp (sa), QUEST_DEV`.QUEST_DEV.dbo.REGION REGION
INNER JOIN
`Oracle_DailyTest`.QUEST_DEV.ADDRESS ADDRESS
ON (REGION.REGION_ID = ADDRESS.REGION_ID)
STATUS:
Waiting for fix in a future release of Toad Data Point.
© ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center