SQL: Get all rows where ID occurs : Given this data set:


> ID	ProductID	quantity
> 
> 1	1	4
> 
> 1	2	13
> 
> 1	4	12
> 
> 1	19	3
> 
> 2	19	4
> 
> 2	22	2
> 
> 2	2	6
> 
> 2	38	1
> 
> 2	14	4
> 
> 3	11	5
> 
> 3	12	6
> 
> 4	13	3
> 
> 4	14	11
> 
> 5	15	2
> 
> 6	16	3
> 
> 7	17	4
> 
> 8	18	9
> 
> 8	19	8


and my result set should look like this:

> ID	ProductID	quantity
> 
> 1	1	4
> 
> 1	2	13
> 
> 1	4	12
> 
> 1	19	3
> 
> 2	19	4
> 
> 2	22	2
> 
> 2	2	6
> 
> 2	38	1
> 
> 2	14	4
> 
> 8	18	9
> 
> 8	19	8

How does this work? i tried different types of subqueries and JOINS but i couldn't manage this.

Thanks for any help in advance!