sql query question?

[Loxton, Ron]

Jon:

	Can you post the query?

Ron

-----Original Message-----
From: Jonathan Schatz [mailto:jon at vmware.com]
Sent: Monday, November 03, 2003 9:22 PM
To: developers at bugzilla.org
Subject: sql query question?


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."



-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=ron.loxton@earthtech.ca>