Help with WHERE clause

[mykeld]

If this were a table

Amount Job_id Crew_id
$100 1 3
$200 2 4
$400 2 4
$600 2 3
$750 2 3
$800 3 7

and i needed a return (WHERE clause) when job_id is the same (i.e 2), and the crew_id is repeated like 4,4 and 33, how would i write it. I am trying to only sum the rows when this condition is fulfilled. Can anyoen help me

 

[Pat Hartman]

I gave you the answer in a different thread. Please don't start new threads on the same topic. If you don't understand an answer, ask for clarification.