ISqlQueryBuilder.UnionAll Method

.NET Standard 2.x

Uses UNION ALL to combine the result set of the current SQL SELECT statement and the result set of another SQL SELECT statement.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Overloads

Method	Description
UnionAll(ISqlQueryBuilder queryBuilder)	Uses UNION ALL to combine the result set of the current SQL SELECT statement and the result set of another SQL SELECT statement generated by the ISqlQueryBuilder object. The combined result set includes duplicate records.
UnionAll(ISqlQueryBuilder queryBuilder, string builderAlias)	Uses UNION ALL to combine the result set of the current SQL SELECT statement and the result set of another SQL SELECT statement generated by the ISqlQueryBuilder object (the combined result set includes duplicate records); and specifies an alias for the ISqlQueryBuilder object.
UnionAll(string sqlRaw)	Uses UNION ALL to combine the result set of the current SQL SELECT statement with the result set of another raw SQL SELECT statement. The combined result set includes duplicate records.
UnionAll(string sqlRaw, string builderAlias)	Uses UNION ALL to combine the result set of the current SQL SELECT statement with the result set of another raw SQL SELECT statement (the combined result set includes duplicate records); and specifies an alias for the raw SQL SELECT statement.