Torque criteria

[sensory21]

Hi

I need to have a new criteria to join two tables in different manner:

table item
==========
stageId
nextStageId


table stage
===========
stageId

the query has to match where stageId from item equals stageId from stage and nextStageId from item equals stageId from stage

can anybody help?

cheers
vero

 

[sedj]

Do you mean in SQL ?

SELECT * FROM item
WHERE item.stageId = stage.stageId
AND item.nextStageId = stage.nextStageId;



--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[sensory21]

No, not in sql in Apache Torque like:

cr.addJoin(ItemPeer.ITEMTYPEID, ItemTypePeer.ITEMTYPEID);

any ideas?
Am i in the right forum?

 

[sedj]

Never used torque, but this link seems to cover joins :

http://db.apache.org/torque/criteria-howto.html

--------------------------------------------------
Free Database Connection Pooling Software

http://www.primrose.org.uk

 

[sensory21]

thanks anyway!