Re: using LIMIT only on primary table - Mailing list pgsql-sql

"Dan Langille" <dan@langille.org> writes:
> If I want all the items on the last 100 orders, I'd start like this:

> SELECT * 
> from orders, order_items 
> where order_items.order_id = orders.id
> LIMIT 100

I think you want

SELECT * 
from (SELECT * from orders order by ID DESC limit 100) as recent_orders, order_items 
where order_items.order_id = recent_orders.id
        regards, tom lane