I'm having trouble doing a specific search through sqlite. I am using this command to join two tables:
SELECT p.idpovoamento,p.ostricultor,p.data_inicial, b.data_coleta,b.sistema_producao,b.qauntidadetotal,b.estagio_crescimento FROM povoamento as p LEFT JOIN biometria AS b ON idpovoamento = “id-dos-povoamentos”;
that returns me:
This red part is the error that I want to correct because it is showing all collection dates.
How do I show only the date of the most recent collection from each grower?
In the case each ostriculator can have several biometrics and so I wanted to show only the latest of them