My understanding is that the Heterogeneous Connection Editor uses MySQL, so maybe this is a MySQL question. Is it possible to use ANSI-89 SQL syntax rather than ANSI-92 syntax?
In other words, could I do this:
where table1.column1 = table1.column1;
Instead of this?:
ON (table1.column1 = table1.column1))
Also, what is the MySQL ANSI-89 syntax for an outer join?