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
Please login to leave a reply, or register at first.