Query query = new Query();
query.Select("c.fname,c.lname,s.order_date,s.id");
query.From("Customer", "c");
query.Join("Sales_order", "s", "s.cust_id", "c.id");
AttributeTest ts = new AttributeTest();
ts.Attribute = "lname";
ts.Value = "Smith";
ts.Operator = AttributeTest.EQUAL;
query.TestCriteria = ts;
QueryResultSet qrs = SUP101DB.ExecuteQuery(query);
while (qrs.Next())
{
string fname = qrs.GetString(1);
string lname = qrs.GetString(2);
int orderId = qrs.GetInt(4);
// ...
}