|
srascheli
Starting Member
Venezuela
7 Posts |
 Posted - 09 March 2001 : 15:56:35
|
Does Access accept the LIMIT clause in a SQL statement? It doesn't seem to be working for me on this sql:
SELECT maestros.maeid AS maeid, maestros.nombre as nombremaestro, maestros.apellido, escuelas.nombre as nombreescuela, escuelas.ciudad, paises.nombre AS nombrepais FROM maestros, escuelas, paises WHERE maestros.escid=escuelas.escid AND maestros.apellido LIKE 'R%' AND paises.paiid = escuelas.paiid ORDER BY maestros.apellido, maestros.nombre LIMIT 1,10
Where can I find a SQL explanation of all clauses I can use in a MSAccess query?
Help please...
|
|
Topic Locked
