Message - From: "Rob Nikander" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, August 30, 2006 3:09 PM
Subject: limit clause on join results
Hi all,
I'm trying to show pages of results in a web app, 30 items per page.
But my main query is a join, and I can't use a simple &
Hi all,
I'm trying to show pages of results in a web app, 30 items per page.
But my main query is a join, and I can't use a simple "limit" clause to
return the 30 items (with the desired offset), because the join is
between two tables with a one-to-many relationship, and I want 30 of
the objects
