subject:"\[sqlite\] group by optimization"

Re: [sqlite] group by optimization

2008-03-21 Thread Igor Tandetnik

L B <[EMAIL PROTECTED]> wrote: > Hi all, > I have this query: > > select CATALOGUES.idcatalogue, CATALOGUES.type, PERSONS.surname, > max(HISTORY.startingfrom) as maxdate > FROM PERSONS > INNER JOIN CATALOGUES > ON CATALOGUES.idperson = PERSONS.idperson > INNER JOIN HISTORY >

[sqlite] group by optimization

2008-03-21 Thread L B

Hi all, I have this query: select CATALOGUES.idcatalogue, CATALOGUES.type, PERSONS.surname, max(HISTORY.startingfrom) as maxdate FROM PERSONS INNER JOIN CATALOGUES ON CATALOGUES.idperson = PERSONS.idperson INNER JOIN HISTORY ON HISTORY.idcatal