| |
|
|
| | есть 2 таблицы, необходимо вывести значение одной колонки общим списком.
есть запрос
SELECT photo.id_factory,
photo.id AS id_photo,
factory.id AS id_factory,
factory.name AS name_factory,
photo.url AS url_photo,
factory.url AS url_factory
FROM `photo`
LEFT JOIN `factory`
ON photo.id_factory=factory.id
LEFT JOIN `type`
ON photo.id_type=type.id
LEFT JOIN `style`
ON photo.id_style=style.id
WHERE photo.id_factory='$factory'
AND photo.published=1
AND type.published=1
AND style.published=1
AND factory.published=1
ORDER BY photo.id_factory
LIMIT $start, $num"
|
а есть запрос
"SELECT other_photo.id_factory,
other_photo.id AS id_other,
factory.id AS id_factory,
factory.name AS name_factory,
other_photo.url AS url_other,
factory.url AS url_factory
FROM `other_photo`
LEFT JOIN `factory`
ON other_photo.id_factory=factory.id
LEFT JOIN `other`
ON other_photo.id_other=other.id
WHERE other_photo.id_other='$o'
AND other_photo.published=1
AND factory.published=1
AND other.published=1
ORDER BY other_photo.id_factory
LIMIT $start, $num"
|
как добавить второй запрос к первому | |
| |
|
