SelectQuery sel = OQL

  .Select(NW.Order.OrderID, NW.Order.OrderDate, NW.Order.RequiredDate)

    ._(NW.OrderDetail)

  .From(NW.Order, NW.OrderDetail)

  .Where(NW.Order.EmployeeID == 5 & NW.Order.ShipVia == 1

    & NW.Order.OrderID == NW.OrderDetail.OrderID);

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

SELECT

  [Orders].[OrderID] , [Orders].[OrderDate] , [Orders].[RequiredDate] ,

  [Order Details].*

FROM

  [Orders] , [Order Details]

WHERE

  [Orders].[EmployeeID] = 5 AND

  [Orders].[ShipVia] = 1 AND

  [Orders].[OrderID] = [Order Details].[OrderID]