How to use multiple join in mysql
snippet in sql

multiple joins mysql


SELECT dashboard_data.headline, dashboard_data.message, dashboard_messages.image_id, images.filename
FROM dashboard_data 
    INNER JOIN dashboard_messages 
        ON dashboard_message_id =
    INNER JOIN images
        ON dashboard_messages.image_id = images.image_id 

How to use multiple join in mysql


SELECT name, id,
    t1.add_date add_date, 
    t2.soc_township township_name1,
    t2.soc_name soc_name, township_name
FROM block t1 
INNER JOIN society t2
    ON (t1.soc_id =
INNER JOIN township t3
    ON (t2.soc_township =