Biggest price

[Forever_xxl]

Hello,
I have this problem:
I have this sql query:

SELECT * FROM cars a left join (buyer g ) ON (g.car_id = a.id) where a.termin_end != '0000-00-00 00:00:00' group by a.id order by g.price desc limit 5.

But this sql sentence not working. Left join get first suggestion. I want get biggest price from buyer table.

Very very thanks. Who helps for me.

[HP400]

I think your looking for something like

SELECT * FROM cars a LEFT JOIN buyer g ON a.id = g.car_id WHERE a.termin_end != '0000-00-00 00:00:00' GROUP BY a.id ORDER BY g.price DESC LIMIT 5

[Forever_xxl]

Sorry not working. ;(

[laserlight]

You need to state what database system you are using, what is the relevant database schema, and what exactly you want to select.

[HP400]

Sounds like you are using MySQL with the LIMIT at the end.