Posts
Sort by recent activity
Tables joined by a matching column name
After enabling the "Tables joined by a matching column name" option, candidate list includes self-joins. For example, with the following tables (clear cache after creating tables):
CREATE TABLE Di...
Table name is case sensitive for JOIN ... ON trigger
A candidate list does not appear after JOIN ... ON unless table names have been typed with the correct case.
For example, with the following tables (Clear cache after creating tables):
CREATE TABLE...