I have the queries that I want to combine to one. But I can't seem to get it working. What to do?
This is number one:
SELECT MIN(publish_date) publish_date, magazine_id FROM published GROUP BY magazine_id
This is number two:
UPDATE magazine SET first_published_on = :publish_date WHERE id = :magazine_id
In this case I want to use the data from the SELECT query into the UPDATE query.
Thanks in advance!
fa06 answered question
Have an answer?