成功了，最後下的是

SELECT DISTINCT vip_no, vip_cname, mail_1, branch
FROM VIP
WHERE (branch = '002') AND (mail_1 LIKE '%@%')
ORDER BY vip_cname

多謝各位大大幫忙