Activity overview
Latest activity by EMoscosoCam
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...
Suggestion for a better JOIN
Hello
I would like to suggest the following:
1) After JOIN is typed, in top of the list should appear the tables that the main table has foreign keys with.
2) If a table is selected, the join condi...