Hi All, How can I write the following query in OJB? SELECT * FROM Table1 AS t1JOIN table2 AS t2 ON t1.fld1 = t2.fld1 AND t1.fld2= t2.fld2 AND t1.fld3= 1 Thanks, Krupa
--------------------------------- Be a better pen pal. Text or chat with friends inside Yahoo! Mail. See how.