with the following query?
SELECT * FROM jobs GROUP BY customer_number, job_number HAVING
count(*) 1 ORDER BY customer_number;
:-)
On 7/29/07, John Trammell [EMAIL PROTECTED] wrote:
From: John Kopanas [EMAIL PROTECTED]
Subject: Returning All Rows That Repeat
I want to be able to return all rows
I want to be able to return all rows that have one or more other rows
with the same customer_number and job_number.
So for instance. If their are two jobs in my jobs table with a
customer_number = '0123' and job_number ='12' then I want both of
those jobs to return one right after another so I
John Kopanas wrote:
I want to be able to return all rows that have one or more other rows
with the same customer_number and job_number.
So for instance. If their are two jobs in my jobs table with a
customer_number = '0123' and job_number ='12' then I want both of
those jobs to return one
From: John Kopanas [EMAIL PROTECTED]
Subject: Returning All Rows That Repeat
I want to be able to return all rows that have one or more other rows
with the same customer_number and job_number.
So for instance. If their are two jobs in my jobs table with a
customer_number = '0123
PROTECTED]
Subject: Returning All Rows That Repeat
I want to be able to return all rows that have one or more other rows
with the same customer_number and job_number.
So for instance. If their are two jobs in my jobs table with a
customer_number = '0123' and job_number ='12' then I want
: John Kopanas [EMAIL PROTECTED]
Subject: Returning All Rows That Repeat
I want to be able to return all rows that have one or more other rows
with the same customer_number and job_number.
So for instance. If their are two jobs in my jobs table with a
customer_number = '0123' and job_number ='12