nid
left join campaccommon.committee c on r.comm_id = c.Comm_id
where
recordtype = "INDIVIDUAL"
and c.party = "D"
and r.amount >= 1
Returns 294 records.
Thanks for any insight you can offer.
- Leo Siefert
hanks for the info, and for the query syntax to work around the
problem. I still think this is a bug in processing the nested query,
and if it is runing the subquery for each line in the master table, i
think that is incorrect.
- Leo Siefert
"Leo Siefert" <[EMAIL PROTECT
OS: Win2k Server
MySQL: 4.1.1 alpha / 4.1.3 beta
Table type: INNO DB
In my production environment, running the query:
select * from main where id in
(select main_id from receipt group by main_id having COUNT(*) > 5)
will hang the server - sometimes for over a day, thugh it seems it will
event
