}/// <summary>
/// https://www.sqlshack.com/sql-union-overview-usage-and-examples/
/// </summary>
/// <param name="select"></param>
/// <returns></returns>
public static UnionClass UnionExcept(this CanUnion left, SqlStatementKeywordBase select)
{
return(new UnionClass(left, " except ", select));
}
/// <summary>
/// https://www.sqlshack.com/sql-union-overview-usage-and-examples/
/// </summary>
/// <param name="select"></param>
/// <returns></returns>
public static UnionClass UnionIntersect(this CanUnion left, SqlStatementKeywordBase select)
{
return(new UnionClass(left, " intersect ", select));
}
/// <summary>
/// https://www.sqlshack.com/sql-union-overview-usage-and-examples/
/// </summary>
/// <param name="select"></param>
/// <returns></returns>
public static UnionClass UnionAll(this CanUnion left, SqlStatementKeywordBase select)
{
return(new UnionClass(left, " union all ", select));
}/// <summary>
