#1054 - Unknown column ... in 'having clause'
Posted on 2005-04-19
Can somebody see what's the problem with following SQL-statement. I've tested in Access and it worked but in MySQL it fails.
FROM recipient re,recipient2targetgroup r2t
WHERE re.recipient_id=r2t.recipient_id and r2t.targetgroup_id=26
and re.recipient_id in(
FROM recipient r, recipient2targetgroup t
GROUP BY r.recipient_id, t.recipient_id
having r.recipient_id = t.recipient_id and count(t.recipient_id) > 1 )
I get following error:
#1054 - Unknown column 'r.recipient_id' in 'having clause'
Thanks for the assistance.