Can you post the sql for the two tables? Not very clear what your saying. Try the code below but I would be amazed if it's what you want.
Code:SELECT DISTINCT cust_email FROM customers, cust_packages WHERE cpack_canceldate <> '0000-00-00' AND customers.cust_custnr = cust_packages.cust_custnr ORDER BY cust_email ASC;