SelectQuery sel = OQL

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

    ._(NW.OrderDetail)

  .From(NW.Order)

  .InnerJoin(NW.OrderDetail)

    .On(NW.Order.OrderID == NW.OrderDetail.OrderID)

  .Where(NW.Order.EmployeeID == 5

    && NW.Order.ShipVia == 1

  );

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

SELECT

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

  [Order Details].*

FROM [Orders]

  INNER JOIN

    [Order Details]

    ON

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

WHERE

  [Orders].[EmployeeID] = 5 AND

  [Orders].[ShipVia] = 1