public void ToSql(ISqlFormatter sql, Joins aliases, List <string> output)
{
var table = Key.To.Table.ToSql(sql);
var alias = aliases[Key.To.Table];
var left = sql.IdentifierPair(alias, Key.To.Table.Id.DbName);
var right = sql.IdentifierPair(aliases[Key.Table], Key.DbName);
output.Add($"join {table} {alias} on {left} = {right}");
foreach (var join in Joins)
{
join.ToSql(sql, aliases, output);
}
}