Many people encounter problems when using the Cross-Connection Editor or Cross-Connection Query Builder to write a query. Sometimes they ask questions such as: What kind of SQL syntax should I use? Can I use the target database's function in the query? These are all good questions. This article provides information that will help you understand how to use the correct syntax when writing a query in the Cross-Connection Editor or Query Builder.
This is a companion discussion topic for the original entry at https://blog.toadworld.com/how-to-write-a-cross-connection-query-correctly