I have another question regarding Expression in Cayenne : I want my generated SQL like so :
*SELECT ** *FROM *Book B1 *JOIN *OldBook B2 *ON *B1.id= B2.id *WHERE *B1.hit = B2.hit so I used Expression.fromString("Book.hit = OldBook.hit"); ... but it's not affect anything to the generated SQL, even when the String is wrong!!!!?? Can anyone point me the way to do this kind of Query, not to metion SQLTemplate because I know the way to do so! Thank in advance! -- View this message in context: http://cayenne.195.n3.nabble.com/HOW-TO-Creating-a-SelectQuery-has-Expression-like-this-tp3728912p3728912.html Sent from the Cayenne - User mailing list archive at Nabble.com.