Errata

Working with Microsoft Dynamicsâ„¢ CRM 4.0

Errata for Working with Microsoft Dynamicsâ„¢ CRM 4.0

The errata list is a list of errors and their corrections that were found after the product was released.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

Color Key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted by Date submitted
PDF Page 375
query on the bottom of the page

The inner join section doesn't use the alias consistently. Beginning at the FROM portion it is listed as:

FROM FilteredAccount AS CRMAF_FilteredAccount
INNER JOIN FilteredActivityPointer AS CRMAF_FilteredActivityPointer ON
accountid = CRMAF_FilteredActivityPointer.regardingobjectid

but is should be:

FROM FilteredAccount AS CRMAF_FilteredAccount
INNER JOIN FilteredActivityPointer AS CRMAF_FilteredActivityPointer ON
CRMAF_FilteredAccount.accountid = CRMAF_FilteredActivityPointer.regardingobjectid

Without an alias for each column, there is some confusion as to which table the value should come from.

 Anonymous  Mar 14, 2012