Hello,
I would like to get the following sql statement:
SELECT [mmm].[ID],
[mmm].[Subject], [mmm].[MailDate],
[mmm].[Marked]
,(select Count(MonitorMailHistory.id) from MonitorMailHistory where MonitorMailHistory.MailMessageID=mmm.id ) as actions
,(select distinct Count(MonitorMailHistory.ruleid) from MonitorMailHistory where MonitorMailHistory.MailMessageID=mmm.id) as rules
from MonitorMailMessage as mmm
WHERE [mmm].[MailboxID] = 37
How can I make with LLBLGen the nested select?
Maybe you can give an example or documentation link?
Thx