I have the following query:
SELECT
dashboard_data.headline,
dashboard_data.message,
dashboard_messages.image_id
FROM dashboard_data
INNER JOIN dashboard_messages
ON dashboard_message_id = dashboard_messages.id
In order to obtain the image id, I am utilizing an INNER JOIN. In order to get the pictures.filename from the images table, I now want to take that image id.
How can I incorporate that into my search?