SELECT
    *

FROM
    t1

JOIN
    t2 ON (t2.id = t1.id)

JOIN
    t3 ON (t3.id = t1.id)

JOIN
    t4 ON (t4.id = t1.id)



SELECT
    *

FROM
    t1

JOIN (
    t2,
    t3,
    t4
) ON (
    t2.id = t1.id AND
    t3.id = t1.id AND
    t4.id = t1.id
)