sql - Comparing 2 vaues in the same table based on criteria from a different table

Question

What I want is to retrieve all ID''s Where the corresponding value of a color is higher then the corresponding value from a different color.
For example, I want where Value of 'Blue' is larger then the Value of 'Purple' Where the ID's match.

I have the following tables:
Table1

ID  |   Color   |   KeyA    |   KeyB
1   |   Blue    |   AB      |   13
1   |   Green   |   AC      |   15
1   |   Purple  |   AG      |   56
2   |   Purple  |   DF      |   46
2   |   Pink    |   GH      |   67
3   |   Orange  |   GH      |   89
3   |   Green   |   YU      |   97

Table2

KeyA    |   KeyB    |   Value       
AB      |   13      |   55      
DF      |   46      |   34      
YU      |   97      |   56      
DF      |   46      |   23      
AG      |   56      |   34      

IN this example the result will be 1

Only the used Values:

Table1

ID  |   Color   |   KeyA    |   KeyB
1   |   Blue    |   AB      |   13
1   |   Purple  |   AG      |   56

Table2

KeyA    |   KeyB    |   Value       
AB      |   13      |   55      
AG      |   56      |   34      

Answer 1

In this case you should use two time the t2 table .. should be

select t1.ID 
from table1 t1 
inner join t12 on t1.color = 'Blue'  and t12.color ='Purple'
inner join  Table2 t2 ON t1.KeyA = t2.KeyA AND t1.KeyB = t2.KeyB 
inner join  Table2 t22 ON t1.KeyA = t22.KeyA AND t12.KeyB = t22.KeyB 
WHERE  t2.value > t22.value