Comments
Sort by recent activity
I am using 3.6 and when I typed JOIN the list appear showing all the tables (including those that the main table do not have foreign keys with) sorted by name.
After I type ON, I would like that the joined table name appears automatically. If I have chosen the PK of the joined table, after I type "=" I would like that the foreign key of the main table is suggested.
SELECT *
FROM maintable
INNER JOIN joinedtable ON joinedtable.PK = maintable.FK
It would be also nice that when expanding the "*", the duplicated keys should not appear. / comments
I am using 3.6 and when I typed JOIN the list appear showing all the tables (including those that the main table do not have foreign keys with) sorted by name.
After I type ON, I would like that th...