Something

SELECT
characters.char_name,
characters.clanid
FROM
clan_data
Inner Join characters ON characters.clanid = clan_data.clan_id
WHERE
clan_data.clan_id >  '0' AND
characters.clanid NOT IN  ( clan_data.clan_id)