Append join to the joins in the FROM clause and set join's parent to this;
after call this function this owns join then you must not free it.
| this |
a SqlSelectFrom structure |
| join |
a SqlSelectJoin to take from |