Toad Data Point can do heterogeneous joins (joining, say, an Oracle table to a SQL Server table). What SQL Syntax does it use? Where can I learn the functions and syntax options available so I can write these queries?
There are several ways to learn about writing queries in Toad Data Point,
You can use Query Builder to generate your queries.
We also have code snippets based on different providers. To view the snippets, Select View -> Code Snippets.
We also have some tutorial videos on our launch page as well as on ToadWorld. You can watch few of the videos to help building your queries.
Toad Data Point uses MySQL for heterogeneous queries.