forgot to include the generated queries that totally ignore the fact, that
there are two types of messages mapped.
SELECT conversati0_.ConversationID AS Conversa1_16_1_, conversati0_.Name
AS Name16_1_, customerme1_.ConversationID AS Conversa7_3_,
customerme1_.MessageID AS MessageID3_,
customerme1_.MessageID AS MessageID18_0_, customerme1_.Title AS Title18_0_,
customerme1_.MessageContent AS MessageC4_18_0_,
customerme1_.CreatedOn AS CreatedOn18_0_, customerme1_.MessageState AS
MessageS6_18_0_,
customerme1_.ConversationID AS Conversa7_18_0_,
customerme1_.CustomerCreatorID AS Customer9_18_0_
FROM Conversation AS conversati0_ LEFT OUTER JOIN
Message AS customerme1_ ON conversati0_.ConversationID
= customerme1_.ConversationID
WHERE (conversati0_.ConversationID = 253600)
SELECT ConversationID AS Conversa7_1_, MessageID AS MessageID1_,
MessageID AS MessageID18_0_, Title AS Title18_0_, MessageContent AS
MessageC4_18_0_,
CreatedOn AS CreatedOn18_0_, MessageState AS
MessageS6_18_0_, ConversationID AS Conversa7_18_0_, AdministratorCreatorID
AS Administ8_18_0_
FROM Message AS administra0_
WHERE (ConversationID = 253600)
They are different and only one uses the join!
--
Jan
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
