ECTED]
Sent: Friday, May 30, 2003 4:57 PM
To: [EMAIL PROTECTED]
Subject: one query, two tables, two aggregate functions
Hi,
I would like to use one query to compare aggregate values from columns
in two separate tables. I am running mysql 3.23.55 (max). Here is a
simplified table structure:
Hi,
I would like to use one query to compare aggregate values from columns
in two separate tables. I am running mysql 3.23.55 (max). Here is a
simplified table structure:
job
- job_id
- name
quote
- quote_id
- job_id
- quote_amount
actual
- actual_id
- job_id
- actual_amount
I'm trying
