db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: Multiple addJoin with OR
Date Mon, 02 Mar 2009 13:26:48 GMT
> 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?

I do not know a way to do this currently. But are you really sure your 
statement makes sense ? If one row in table B matches, then you get all 
rows of table C joined (or vice versa), and I cannot imagine this is what 
you need. But I might be wrong.

     Thomas
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message