SQL query help - please :)

[mds1256]

Hi
 
I am faced with the following problem.
 
My table is as follows:

 

part_id

supplier_id

customer_id

 

p1

s1

c1

 

p2

s1

c1

 

p3

s2

c1

 

p4

s2

c2

 

p5

s1

c2

 

And I need to return all customer ids where the customer has bought a part from the same supplier more than once.

 

Any help would be appreciated

[mac_gyver]

SELECT customer_id FROM your_table GROUP BY customer_id,supplier_id HAVING count(*) > 1

[mds1256]

SELECT customer_id FROM your_table GROUP BY customer_id,supplier_id HAVING count(*) > 1

 

Thank you!!!

 

That worked exactly, looks simple but have been trying to do this for around 4 hours

 

Much appreciated.