The situation that I would like to handle is: the user is on an Orders screen and they want to search for an order with a particular Product in it. If I used a view for the Browse Dialog that joined Orders and OrderItems I would get multiple rows if I just searched by the Order ID. Since I only want to show a list of orders, I figure the solution would be to use a sub-query (SELECT OrderId FROM OrderItems WHERE OrderItems.item_id = ?).