Hello, I have got problem with ordering records selected by LEFT JOIN, there is a SQL select:
SELECT so.label, so.price, o.name, o.id id, o.location, p.filename, p.format FROM offers o, offers_soffer so LEFT JOIN offers_photos p ON o.id = p.record_id WHERE so.rec_id = o.id GROUP BY (o.id) ORDER BY o.location DESC, p.id ASC there can be more photos in one offer and I have to get 1 photo which is inserted to offer by the first. I tried to "order by p.id", "ORDER BY p.itime" and this doesn't work :/ Have somebody some idea? Thank you very much for all help. Jiri Nemec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]