SEI Subqueries

How are subqueries performed in SEI without creating a custom DB view ?

Creating an Order Shortage Report.

I have a process that pull sinformation form the ITMMVT table in summary (Orders, Item info) but I need to join to the ORDERS table to find the earliest PO.

1 to many relationship.

I can solve this in SQL (view) but can it be done in SEI ?