SELECT
characters.clanid,
characters.char_name,
FROM
characters ,
clan_data
WHERE
characters.clanid NOT LIKE  ( clan_data.clan_id) AND
characters.clanid NOT LIKE  '0'