Database

Select This, null That
from SomeTable

Union
Select This, That
from SomeTable
 left join ThatTable on ...

select 101
union
select null
union
select  102
union
select null

using (OleDbConnection con=new OleDbConnection(connectionString)) {
	con.Open();
	using (OleDbCommand cmd=new OleDbCommand("SELECT * FROM ["+tableName+"]", con)) {
		// ref: http://www.pcreview.co.uk/forums/getschema-columns-results-t2877051.html
		DbDataReader rdr=cmd.ExecuteReader(CommandBehavior.SchemaOnly);
		DataTable schema=rdr.GetSchemaTable();
		foreach (DataColumn col in schema.Columns) log("colName="+col.ColumnName);
	}
}

StringBuilder sSQL = new StringBuilder();
TableDB oTableDB;
sSQL.AppendLine("select T.owner,T.table_name, NVL (V.HasView, 0)HasView");
sSQL.AppendLine("From SYS.ALL_TABLES T ");
sSQL.AppendLine("left join (select owner,view_name, 1 HasView from SYS.ALL_VIEWS where owner in ('SchemaName1','SchemaName2')) V on upper(V.View_Name) = 'VW' || T.table_name ");
sSQL.AppendFormat("and V.owner = T.owner").AppendLine();
sSQL.AppendFormat("where T.owner in ({0})", sSchema.ToString()).AppendLine();
sSQL.AppendLine("order by table_name");

if (oDBOpsO == null || oDBOpsO.Creds.Database != oDB.DatabaseName)
{
    oDBOpsO = clsMain.GetDBOpsO(oDB.Server.ServerName, oDB.DatabaseName);
}

DataTable dtData = oDBOpsO.GetTableSQL(sSQL.ToString());

TableDB oTable = new TableDB();
List<TableDB> lTbl = new List<TableDB>();
foreach (DataRow orow in dtData.Rows)

AND owner = 'myowner'

foreach (DataRow row dt.Rows) {
    listViewColumns.Items.Add(row[0].ToString());
}

string Sql = "select column_name from all_tab_columns where table_name = '" + sSelectedTable + "' order by column_id";
                       OleDbCommand Comm = new OleDbCommand(Sql, Conn);

                       listViewColumns.Items.Clear();

                       try
                       {
                           //List the schema info for the selected table
                           OleDbDataAdapter da = new OleDbDataAdapter(Sql, Conn);
                           DataTable dt = new DataTable();
                           da.Fill(dt);

                           foreach (DataRow row in dt.Rows)
                           {
                               listViewColumns.Items.Add(row[0].ToString());
                           }
                       }

PDTUM wrote:

Mr Holmes Shameel

PDTUM wrote:

PLEASE accept my apology...

PDTUM wrote:

I hope that you will want to respond to me the next time

select max(serialnumber), Name, City, State
  from YourTable
 group by Name, City, State

select yourtable.serialnumber, yourtable.name, yourtable.city, yourtable.state 
from yourtable 
Inner join (
    select Max(serialnumber), state
    from yourtable 
    group by state) as sub1
on yourtable.serialnumber = sub1.serialnumber