nevermind, this does it:
select er.equipmentRepairId as equipmentRepairId
| from EquipmentRepair er, Equipment e
| where er.equipment.equipmentId = e.equipmentId
| and e.equipmentId = 1
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4217557#...
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...