public static void AllWithInnerJoint()
{
var query = (SqlQueryExpression)SqlExpression.Parse("SELECT * FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.other_id");
var statement = new SelectStatement(query);
var sql = statement.ToString();
var expected = "SELECT * FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.id = t2.other_id";
Assert.AreEqual(expected, sql);
}