Find max entry in an JOIN

Muiter · #1 (**permalink**) 03-31-11, 02:36

I have this query:

Code:

SELECT
plt_id.id AS id,
plt_id.dikte AS dikte,
plt_id.dikte_gemeten AS dikte_gemeten,
plt_id.attest AS attest,
plt_nr.plaat_id_id AS plaat_nr_id,
plt_nr.plaat_no AS plaat_no,
plt_nr.moeder_plaat AS moeder_plaat,
plt_nr.locatie AS locatie,
plt_afm.aantal AS aantal,
plt_afm.lengte AS lengte,
plt_afm.breedte AS breedte,
FROM plaatregistratie_afm AS plt_afm
LEFT JOIN plaatregistratie_nr AS plt_nr
ON plt_nr.id = plt_afm.plaat_nr_id
LEFT JOIN plaatregistratie_id AS plt_id
ON plt_id.id = plt_nr.plaat_id_id

Is there an way so see of each latest entry in plaatregistratie_afm per plt_nr.plaat_no?

I have tried with no succes:
MAX(plt_afm.plaat_nr_id) AS afm_plaat_nr_id,
And
GROUP BY plt_nr.id

it-iss.com · #2 (**permalink**) 03-31-11, 03:25

Hi,

You are asking "Is there an way so see of each latest entry in plaatregistratie_afm per plt_nr.plaat_no?". Have you considered changing the order of your tables and using plt_nr as the driver with left joins to the other tables? Also do you need to have LEFT JOIN's in your query and use JOIN's instead?