Mysql query error

Question

Mysql query error

Navigation

#1 by (2 votes)
#2 by (1 votes)
#3 by (0 votes)

0

Hello!

Why is the status coming different from the table?

follow my query:

SELECT DISTINCT max(idEmbreagem) as idEmbreagem, b.prefixo as idVeiculo, max(datamontagem) as datamontagem, max(kmmontagem) as kmmontagem, max(horimetromontagem) as horimetromontagem, max(c.km) as kmatual, max(c.horimetro) as horimetroatual, a.'status', max(tipoembreagem) as tipoembreagem, (max(c.km) - max(a.kmmontagem)) as kmrodados FROM embreagem a
              JOIN veiculos b on (a.idVeiculo=b.idVeiculo)
              JOIN hodometro c on (a.idVeiculo=c.idVeiculo)
              GROUP BY a.idVeiculo order by idVeiculo ASC

php mysql mysqli

asked by anonymous 24.06.2018 / 05:52

3 answers

How to put a php variable in a mysql query? Error: "unable to connect to cache daemon: Permission denied" when not using SUDO

score 2 · Answer 1

Friend, ditinct with max ... Something looks really bad there ... = /

The fact is that the distinct and MAX () 's are messing up the results, shuffling them ... You should think better of putting this query together.

score 1 · Answer 2

1

Because you are bringing several max in the query, it is shuffling the results with max of each select following the conditionals.

24.06.2018 / 15:31

score 0 · Answer 3

If you want to get the latest data from the embreagem and hodometro tables, do so:

SELECT b.idembreagem, a.prefixo idveiculo, a.datamontagem,
       a.kmmontagem, a.horimetromontagem, c.km kmatual,
       c.horimetro horimetroatual, b.status, b.tipoembreagem,
       (c.km - a.kmmontagem) as kmrodados
FROM veiculos a
JOIN embreagem b ON b.idveiculo = a.idveiculo
JOIN hodometro c ON c.idveiculo = a.idveiculo
WHERE b.idembreagem IN (SELECT MAX(idembreagem) FROM embreagem GROUP BY idveiculo)
AND c.idhodometro IN (SELECT MAX(idhodometro) FROM hodometro GROUP BY idveiculo)
ORDER BY a.prefixo ASC