Access 导出SQL 源码SELECT RecievedAll.[Recipient-Address], IIf(IsNull(RecievedInternal![Number-Recieved-Mail]),0,RecievedInternal![Number-Recieved-Mail]) AS InRecd, IIf(IsNull(RecievedInternal![Total-Size-MB]),0,RecievedInternal![Total-Size-MB]) AS InRecdSize, IIf(IsNull(SentInternal![Number-Sent-Mail]),0,SentInternal![Number-Sent-Mail]) AS InSent, IIf(IsNull(SentInternal![Total-Size-MB]),0,SentInternal![Total-Size-MB]) AS InSentSize, IIf(IsNull(RecievedExternal![Number-Recieved-Mail]),0,RecievedExternal![Number-Recieved-Mail]) AS ExRecd, IIf(IsNull(RecievedExternal![Total-Size-MB]),0,RecievedExternal![Total-Size-MB]) AS ExRecdSize, IIf(IsNull(SentExternal![Number-Sent-Mail]),0,SentExternal![Number-Sent-Mail]) AS ExSent, IIf(IsNull(SentExternal![Total-Size-MB]),0,SentExternal![Total-Size-MB]) AS ExSentSize, [InRecd]+[InSent]+[ExRecd]+[ExSent] AS TotalNum, [InRecdSize]+[InSentSize]+[ExRecdSize]+[ExSentSize] AS [Total-Size] FROM (((RecievedAll LEFT JOIN RecievedInternal ON RecievedAll.[Recipient-Address]=RecievedInternal.[Recipient-Address]) LEFT JOIN SentInternal ON RecievedAll.[Recipient-Address]=SentInternal.[Sender-Address]) LEFT JOIN RecievedExternal ON RecievedAll.[Recipient-Address]=RecievedExternal.[Recipient-Address]) LEFT JOIN SentExternal ON RecievedAll.[Recipient-Address]=SentExternal.[Sender-Address];
FROM (((RecievedAll LEFT JOIN RecievedInternal ON RecievedAll.[Recipient-Address]=RecievedInternal.[Recipient-Address]) LEFT JOIN SentInternal ON RecievedAll.[Recipient-Address]=SentInternal.[Sender-Address]) LEFT JOIN RecievedExternal ON RecievedAll.[Recipient-Address]=RecievedExternal.[Recipient-Address]) LEFT JOIN SentExternal ON RecievedAll.[Recipient-Address]=SentExternal.[Sender-Address];