----- Original Message -----
From: "Harald Fuchs" <[EMAIL PROTECTED]>
> In article <[EMAIL PROTECTED]>,
> "Jigal van Hemert" <[EMAIL PROTECTED]> writes:
>
> > SELECT t1.`msg_id`
> > FROM `msg_content` AS t1
> > JOIN `msg_addressee` AS t2 ON t1.`msg_id` = t2.`msg_id` AND
> > FIND_IN_SET( t2.`status` , 'deleted' ) >0
> > LEFT JOIN `msg_addressee` t3 ON t1.`msg_id` = t3.`msg_id` AND
> > FIND_IN_SET( t3.`status` , 'deleted' ) =0
> > GROUP BY t2.`msg_id` , t3.`msg_id`
> > HAVING COUNT( t3.`msg_id` ) =0
Which contains an error in de FIND_IN_SET(), I noticed...
> Try the following:
>
> SELECT t1.msg_id
> FROM msg_content t1
> LEFT JOIN msg_addressee t2 ON t1.msg_id = t2.msg_id
> AND FIND_IN_SET ('deleted', t2.status) = 0
> WHERE t2.id IS NULL
Thanks, I wasn't thinking so clearly anymore last Friday ;-)
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
