mark_roach - 10:14 am on Oct 11, 2012 (gmt 0)

You need to join the table with itself. Try something like this (untested):

select a.apple_id from table a, table b where a.apple_id=b.apple_id and a.type_id='Color' and a.type_value='Red' and b.type_id='Size' and b.type_value='Small'