| |
|
|
| | Есть запрос:
SELECT `reports`.`name` , `reports`.`place` , `reports`.`time` , `reports`.`description` , `reports`.`id_report` , `photos_reports`.`image`
FROM (
`reports`
)
LEFT JOIN `photos_reports` ON `reports`.`id_report` = `photos_reports`.`id_report`
WHERE `reports`.`id_report` = '2'
ORDER BY `reports`.`id_report` DESC
LIMIT 0 , 30
|
Возвращает:
name
place
time
description
id_report
image
WHite
Moscow
34242424
Opisanie
2
12313
WHite
Moscow
34242424
Opisanie
2
|
Нужно удалить повторения и оставить лишь поля images | |
| |
|
|
| |
|
|
| |
для: OLi
(02.09.2012 в 21:03)
| | | Попробуйте следующий запрос
SELECT
`photos_reports`.`image`
FROM
`reports`
LEFT JOIN
`photos_reports`
ON
`reports`.`id_report` = `photos_reports`.`id_report`
WHERE
`reports`.`id_report` = '2'
GROUP BY
`photos_reports`.`image`
ORDER BY
`reports`.`id_report` DESC
LIMIT 0 , 30
|
| |
| |
|
|
