Need ur help in create sql statement

[abouelela88]

I want to run this SQL statement (select item.itemnum from item
where item in(select itemcondition.conditioncode,itemcondition.condrate,itemcondition.itemnum from itemcondition where itemcondition = '100'))
in maximo and i use 2 application actuate v8 and maximo v6.2.


plz help me in this problem.

thanks and regards