heyy..help me
There is following code written in SQL query but i want to write in hibernate criteria..
and also tell me how to join 3 table using inner join in hibernate criteria.

select
SC.IMEI,CalledNumber,Charge
,MSISDN
,Customername
from satellite.cdrbean AS SC Inner Join
satellite.Isubean AS SI ON Sc.IMEI = SI.IMEI Inner Join
Satellite.Customerbean AS SCU ON SI.CustomerID = SCU.CustomerID
where sc.IMEI = '3000340133110908'

In that,

I have 3 tables CDRbean,ISUbean and Customerbean..in that i want data with the condition of IMEI number...
please help me