Select All the Fields

SelectQuery sel = OQL

  .Select(NW.Order)

  .From(NW.Order)

  .Where(OQL

    .Criteria(NW.Order.EmployeeID).EQ(5)

    .And(NW.Order.ShipVia).EQ(1)

  );

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

SELECT [Orders].*

FROM [Orders]

WHERE

  [Orders].[EmployeeID] = 5 AND

  [Orders].[ShipVia] = 1

== Equal to the following SQL [Oracle] ==

SELECT "Orders".*

FROM "Orders"

WHERE

  "Orders"."EmployeeID" = 5 AND

  "Orders"."ShipVia" = 1

The preceding query can also be written in this way:

SelectQuery sel = OQL

  .Select(NW.Order)

  .From(NW.Order)

  .Where(NW.Order.EmployeeID == 5

    && NW.Order.ShipVia == 1);

It can be simplified in the following way:

SelectQuery sel = OQL

  .SelectFrom(NW.Order)

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

Or:

SelectQuery sel = OQL

  .SelectWhere(NW.Order.EmployeeID == 5 && NW.Order.ShipVia == 1);

Related Topics

Single Table Select