Re: SQL query may not be enough, what else should I try?

From: Craig Orson Oakland (COO I) <dotacion.nospam_at_st-helena.zzn.com>
Date: Thu, 23 Mar 2000 13:52:11 -0800
Message-ID: <8be3h2$c83@gap.cco.caltech.edu>

FWIW....
I wound up creating a temp table (because the view created was too darn slow) to help the process along.

Main Query selects all current undergrads and links to three sub-queries Temp_Table holds person_id and units of all students having earned_units

Sub_Query_1 selects where person_id not in the temp_table
Sub_Query_2 selects person_id and units < 18 from temp_table
Sub_Query_3 selects other attributes for a student (email, status, , etc.)

When the report is run the do_sql function runs the table scripts and populates it using a select query of all current students having units > 0

--
(:(-(=(Craig O. Oakland (COO I)=)-):)
http://home.pacbell.net/oioioioi/ Received on Thu Mar 23 2000 - 15:52:11 CST