SELECT a.*, c.*, b.*
FROM
    `creature` a
        INNER JOIN
    `creature_template` b
        ON a.id = b.entry
        INNER JOIN
    `npc_vendor` c
        ON b.entry = c.entry;