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.
join
a SqlSelectFrom structure
a SqlSelectJoin to take from