sql query question?

[Jonathan Schatz]

i've hit a wall trying to generate a report for my manager and i figured i'd
ask here. 

for a given range of dates, i need a list of bugs that were filed with a
particular target_milestone. this seems like it should be easy enough to do
with one query against 2 tables (bugs, bugs_activity), but everything i've
come up with has hung my mysql server. 

i've written a program to do this with many queries, and at least i have
results to give my boss, but i feel stupid for not being able to come up with
the correct magic query. any ideas?

-jon
--
Jonathan Schatz
Engineering System Administrator
VMware, Inc
"Te occidere possunt sed te edere non possunt nefas est."