Database

SELECT customer, sum(value1)<br />
FROM my_table<br />
GROUP BY customer

SELECT customer, sum(value1)<br />
FROM my_table<br />
WHERE customer IN ('1111', '9999')<br />
GROUP BY customer

<br />
Select e.Event_ID, e.Event_Date, p.Prod_Name from EVENT e, PRODUCT p, EVENTS_PRODUCTS eps<br />
where e.Event_ID = eps.Event_ID and eps.Prod_ID = p.Prod_ID<br />
order by e.Event_ID p.Prod_Name DESC, e.Event_Date DESC<br />

create table parent(id int primary key, somecolumnnameA varchar(200))<br />
create table child1(id int primary key, parentid int foreign key references parent(id), somecolumnnameB varchar(200))

<br />
using System.Data.OleDB;<br />
<br />
private void FillDataSet()<br />
{<br />
<ul><br />
   OleDbConnection foxConn = new OleDbConnection(<br />
              "Provider=VFPOLEDB.1;Data Source=C:\\DataDirectory");<br />
   OleDbCommand foxCommand = new OleDbCommand();<br />
   OleDbDataAdapter foxDA = new OleDbDataAdapter();<br />
   DataSet foxData = new DataSet();<br />
<br />
   foxCommand.Connection = foxConn;<br />
   foxCommand.CommandType = CommandType.Text;<br />
   foxCommand.CommandText = "SELECT * FROM myTable";<br />
<br />
   foxDA.SelectCommand = foxCommand;<br />
   foxDA.Fill(foxData, "MyTable");<br />
</ul><br />
}<br />