Joins

Walt,
here is the example how you can use joins in ASPRunner 2.1.

Select ID,

OrderDate,

CustomerID,

b.ID as DetailID,

b.Quantity as ProductQuantity

from OrderHeader a

inner join OrderDetail b on

a.ID = b.OrderID

If you like to use joins you need to adjust your SQL query manually on the SQL query tab.
Note: it's recommended to use aliases for fields from joined tables to avoid confusion when two from different tables have the same name.
Sergey Kornilov