Hi! I want to create an SQLQuery that combines data from three tables. Right now, my javacode looks like this:
Criteria.addJoin(TableA.id, TableB.fk); Criteria.addJoin(TableA.id, TableC.fk); This results in this SQL query: . WHERE TableA.id = TableB.fk AND TableA.id = TableC.fk . However, this is not the result I need. What I need is a query with OR instead of AND, like this: . WHERE TableA.id = TableB.fk OR TableA.id = TableC.fk . I haven't found any way to do this using criteria. Is it possible? /Ludwig
