Re: Showing recordsets from tables with one (main table) to many (secondary table) relationship

[Kostas Telias]

Ok, then, i prefer to think about your solution: my application has the possibility of being extended to thousands of records.

If i follow your indications, would it be possible to know when the equal or when the >/< must be used, in the WHERE clause? I would need to compound a WHERE clause with several parts, as many as orders applied; for example, if only two orderings (genus and scientificname) has been applied:

SELECT * FROM tbltaxonomia
WHERE (family='Gramineae'
AND genus='Avena'//perhaps =, or perhaps >/<
AND scientificname > 'Avena sativa')//perhaps >, or perhaps =
ORDER BY genus, scientificname

In the other hand, would it be possible to show, for example, the record number 40 (according to that order) of the 50 records with family='Gramineae'?

Thank you.