I am a returning member, back after a long time absence, with a question.
I am brand new to EJB, using RAD6. I have developed a couple of EJB projects but now need a more advanced query, but have no experience with them. the query in SQL would look like
Select * from Violation v where v.violationValue = ?1 and v.sourceId in (Select sourceId from Source s where s.vendorId = ?2)
How do I define this in the RAD tool, or EQL in general? Source has a one to many relationship to Violation, It is navigable from Source to Vaiolation, but not the otherway. I am now wondering if I need to change this.
If someone can give me a little guidance here I would really appreciate it.