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 20 row total. It's possible to restrict the above query without have to select 20 id from tableA and query again the DB to retrieve other n records? Daniel