Re: Help with LIMIT

At 3:08 PM +0200 9/19/03, Daniele Tagliavini wrote: Hi, I have a question for the LIMIT clause. I have two table with relation 1:n and a query like this : SELECT tableA.id, tableB.name FROM tableA INNER JOIN tableB ON tableA.id=tableB.id WHERE something LIMIT x, 20 I want to restrict the result

Help with LIMIT

Hi, I have a question for the LIMIT clause. I have two table with relation 1:n and a query like this : SELECT tableA.id, tableB.name FROM tableA INNER JOIN tableB ON tableA.id=tableB.id WHERE something LIMIT x, 20 I want to restrict the result to 20 row from tableA and n row from tableB and not