Actually, I glad you replied because now I don't have to go searching for this thread. I guess I was brain dead the other day and missed the obvious answer.

SELECT *
FROM orders INNER JOIN ordlines
orders.orderid = ordlines.orderid
WHERE orders.orderid IN (
SELECT TOP 3 orderid
FROM orders
ORDER BY orderdate DESC)

-Mike