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:
select table1.column1,
table2.column1
FROM table1,
table2
where table1.column1 = table1.column1;
Instead of this?:
select table1.column1,
table2.column1
FROM (table1
INNER JOIN
table2
ON (table1.column1 = table1.column1))
Also, what is the MySQL ANSI-89 syntax for an outer join?