public void BuildExpression_ANSIJoin()
{
MySQLBuilder sqlBuilder = new MySQLBuilder();
sqlBuilder.AddSelectClause("id");
sqlBuilder.AddFromClause("foo");
sqlBuilder.AddJoinClause("LEFT JOIN", "bar", "bar.id = foo.id");
StringBuilder stringBuilder = new StringBuilder();
sqlBuilder.BuildExpression(stringBuilder);
Assert.AreEqual("SELECT DISTINCT id FROM foo LEFT JOIN bar ON bar.id = foo.id;", stringBuilder.ToString());
}