How to do this in OJB

[k jee]

Hi All,
  
  I need some advice on how to achieve the following with ojb.
  
  Select T1.FLD1,T1.FLD2, T2.FLD2,T2.FLD3,T3.FLD1,T3.FLD2,T3.FLD4 from table1 
T1, table2 T2, Table3 T3,Table4 T4 where
  (T4.key1="XYZ") and(T3.somefield in ("A","B")) and (
  (T4.FLD3 = T1.FLD3) and (T4.FLD3 =T2.FLD3) and (T4.FLD3= T3.FLD3)).
  
  Thanks you in advance,
  Krupa
  
  
  
                
---------------------------------
How low will we go? Check out Yahoo! Messenger’s low  PC-to-Phone call rates.