I have two queries that are very similar. One of the queries takes a few
minutes (3:43:07 last run) to complete, while the other takes less than
a second to complete.
I know these are two different queries and shouldn't take the same
amount of time, but I based the fast query on the slower one.
I'm having trouble with a query that is supposed to grab a field from each of my
tables. and set up a Total line at the bottom of each set.
I have:
Insurance Company table (insco)
Patient table (patient)
Procedure table (procrec)
Charges table (feeProfiles)
Patient Coverage table (coverage)
Proc
I need to get totals for the data in my database. I stumbled upon the
"WITH ROLLUP" modifier
(http://www.mysql.com/doc/en/GROUP-BY-Modifiers.html) and it appears to
be exactly what I'm looking for, except for the fact that when I try to
use it I get the following message:
This version of MyS