SQLite a difficult sql query

I hope you can help me get a SQL query for the following:

Table is like this:

[PRKEY] [ID] [ID2] [Value] [Value2] 

[PRKEY]: Primary key 
[ID]: like a main catogory, a integer that is the same for a unknown amount of subcatogory of [ID2] 
[ID2] like a subcatagory, a integer that is the same for a unknown amount of [Value]: [Value2]
[Value]: a TEXT column
[value2]: a TEXT column

Now what I have is [ID] and Allot of [Value] and [Value2] And I want [ID2] that belongs to the amount of [Value] and [Value2] i know

What is the best way of accomplishing this?