1.SELECT a.field1,a.field2, ....
start editing after SELECT, just before a
2.SELECT b.a.field1,a.field2, ....
3.wait a split of second, since b is valid table drop down appears with selection of fields, move with down arrow press enter -->
4.SELECT b.field1.field1,a.field2, ....
se how 'a' from 'a.field1' has been eaten out.
Bug in sql editor
BubikolRamios posted 5 years ago
It helps if you put space before a.field1 before start editing (i.e. start editing just after SELECT), but I fill that should be repaired, since MYsql ignores spaces.
Please login to leave a reply, or register at first.