RSS Feed

Plugin Developer Discussion

When joining tables to a query we can specify an alias.  It doesn't seem possible to do the same for the first table.  Specifically:

var query = api.Database.NewSelectQuery(MyTable);
query.AddInnerJoin(OtherTable, OnClause, "O");

In the first line, there is no way to specify an alias for MyTable which would be useful in other clauses (where, on, etc).

Yep, unfortunately we missed this in v1 so there's currently no way to do it.