Yes, they have 1-n relationship "toOldBook", I tested "book.hit = toOldBook.hit" (Wrong) "Book.hit = toOldBook.hit" (Wrong) "hit = toOldBook.hit" (Wrong)
but "toOldBook.hit = 1" ( Correct) weird "toOldHell = 1" (nothing name to oldHell of course) the query still run without any exception??? In case you want to know , book.hit and OldBook.hit both is INTEGER ... So I really confuse about, can Cayenne really understand the complex WHERE like that... -- View this message in context: http://cayenne.195.n3.nabble.com/HOW-TO-Creating-a-SelectQuery-has-Expression-like-this-tp3728912p3728983.html Sent from the Cayenne - User mailing list archive at Nabble.com.