my query returns mysql error 1267....why????

[Joseph Puths]

hello...

my query is not working... i am using 2 databases...
query is as follows
SELECT DISTINCT (date_format(BEGIN_DATE,'%d-%m-%Y')),
COUNT(*),
BEGIN_DATE,
SEC_TO_TIME(SUM(DUR_SEC)), SEC_TO_TIME(SUM(DUR_SEC+TIME_TO_SEC(TimeB)-TIME_TO_SEC(TimeA))),
SUM(CardCall) ,
SUM(ResellerCall)
FROM call_details
WHERE BEGIN_MONTH=06 AND
BEGIN_YEAR = 2005 AND
CardSerialNumber IN (Select serno from ppcc.card_details )###here i am queryin from another database
GROUP BY BEGIN_DATE

and the query is returning the error
ERROR 1267: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_bin,IMPLICIT) for operation '='

please help me... thanks in advance