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’.
`alvdpeabody2.prod.quest.corp (sa), QUEST_DEV`.QUEST_DEV.dbo.REGION REGION
ON (REGION.REGION_ID = ADDRESS.REGION_ID)
Waiting for fix in a future release of Toad Data Point.
© 2020 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책