ScalarList selectList = new ScalarList();

selectList.Add(NW.Order.OrderID);

selectList.Add("Orders.OrderDate");

selectList.Add(NW.Customer.CompanyName);

VectorList fromList = new VectorList();

fromList.Add(NW.Order);

fromList.Add("Customers");

SelectQuery query = OQL

  .Select(selectList)

  .From(fromList);

The SQL statements generated as follows (taking SQL Server as an example)

SELECT

  [Orders].[OrderID] , Orders.OrderDate , [Customers].[CompanyName]

FROM

  [Orders] , Customers