JOINs

I may be trying to do too much in a single query here, but it would be nice if I could get it working! Apparently, the version of MySQL used by my work does not support the WITH ROLLUP feature, otherwise I think that would work. What I have are 3 tables: gc_info, amends, payments. 'gc_info'

Re: JOINs

Patrick, Thanks! But - same result... It was worth a shot, however I still got 12 instances of 'amend' instead of 1. If I can't work it out, I'll just split up this one query into two and see about using PHP to do the math. Not something I wanted to do, but it should work just as well. Thanks

Re: JOINs - More Info

would be okay. Thanks again! Jason - Original Message - From: Jason Soza [EMAIL PROTECTED] Date: Tuesday, August 19, 2003 11:18 am Subject: JOINs I may be trying to do too much in a single query here, but it would be nice if I could get it working! Apparently, the version of MySQL used

Design

. Jason Soza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL

Connecting

(), and the user/pass combos I'm using I use just fine to maintain and update the database, i.e. these are known good user/pass combos. Any idea what's happening? Jason Soza - Before posting, please check: http://www.mysql.com

Stupid Q

Hoping someone can help me here: I've made a column using SET(y,n) NOT NULL - I want the default value in that column to be n, so if no data is entered for that column, it'd be n automatically. How do I do that? Not sure what to search for in the manual. Jason Soza filter fodder: sql, query

RE: Query Problem

To: Jason Soza; [EMAIL PROTECTED] Subject: RE: Query Problem Other than it is uglier than a Hut? The higest ideals of a database is to separate data into tables that keep track of data for the same objects. Some databases break these rules (oh and how) for simpler queries, and sometimes for faster

RE: Query Problem

! It works now, though! Yay! This is pretty cool. I'll have to let you know when I finish all of this - I'll be using PHP to display all this info via HTML. That'll be another fun project... Thanks again for your help! Jason -Original Message- From: Jason Soza [mailto:[EMAIL PROTECTED]] Sent

Re: Query Problem

of the manual are not turning up much. Thanks, Jason Soza - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

RE: Query Problem

? Jason Soza - Original Message - From: Opus [EMAIL PROTECTED] Date: Thursday, May 23, 2002 4:50 pm Subject: RE: Query Problem Jason, First, as to the structure of the database. I agree with Sammy, you probably don't need 3 tables linking data together. A more generic structure

Query Problem

only 3 of 5 or 7 of 10 are missing. Any help would be greatly appreciated. Thanks in advance. Jason Soza Jason Soza '92 Twin Classic Red Miatae Juneau, Alaska http://www.phrog-net.com/sparkles/ http://www.miatapix.net --Is YOUR Miata here

RE: Query Problem

: Wednesday, May 22, 2002 8:18 PM To: Jason Soza Cc: [EMAIL PROTECTED] Subject: Re: Query Problem to make it easier for others to help you. you should have posted the create table statement, insert statement for a small set of data so that anyone of us could easier reproduce your problem. btw, are you