Re: using LIMIT only on primary table

"Dan Langille" <dan(at)langille(dot)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