Currently, when creating a new DatabaseObjects.SQL.SQLSelect object it will by default select all fields. However, when utilising a table join and attempting to select all fields from one table and one or more fields explicitly from another table this is not possible.
Related to Allow accessing associated SQLSelect object from IDatabaseObjects.TableJoins
Added * expression for indicating to select all fields from a table. …
This is particular relevant when utilising the TableJoins because by default all fields are selected, however sometimes aliases need to be added to particular fields.