Igor,
That's not quite true. ORDER BY and LIMIT are allowed in sub-selects, as is the case here. This query works, I tested it before posting.
Your query returns 2 records instead of 4. I'm testing it on SQLite v3.3.10 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------