s
crapping out 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
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'
ohn 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 thei
>> 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
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 right
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 ca
