/// <summary>
/// Serializes all of the tables from the SELECT statment.
/// </summary>
public virtual string SerializeSelectTables(SQLSelectTables selectTables)
{
var strSQL = String.Join(", ",
selectTables
.Where(table => selectTables.Joins == null || !selectTables.Joins.Exists(table))
.Select(table => SerializeSelectTableBase(table))
.ToArray());
if (selectTables.Joins != null)
{
string strJoinsSQL = SerializeSelectTableJoins(selectTables.Joins);
if (strJoinsSQL != string.Empty && strSQL != string.Empty)
strSQL += " ";
strSQL += strJoinsSQL;
}
return strSQL;
}
public SQLSelect()
{
pobjTables = new SQLSelectTables(this);
}