1. The join is correct. You ask for the number of publications belonging to a specific BlaInteraction. That is what the SQL expresses. 2. Is it really important? 3. If it is, add the interaction id as a readonly property on the publication, and query on that.
/G 2011/9/9 csetzkorn <[email protected]> > Hi experts, > > Could you please be so kind and have a look at this: > > > http://stackoverflow.com/questions/7359783/prevent-unnecessary-cross-joins-in-count-query-of-generated-sql-code > > Thanks. > > Christian > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
