Toad World® Forums

Can I user ANSI-89 SQL in the Heterogeneous Connection Editor?

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?

You are correct - the x-query uses MySql. Inner join can be specified in either the FRON or WHERE clause. And the result will be the same.

Outer join condition can return different results depending on whether the join in the FROM or WHERE clause. That’s why it’s deprecated in modern databases.

I suggest to specify the joins in the FROM clause.

Regards

Aleksey