This data can be found in the Amount field of the PROPOSAL_SOLICITOR table. If you wish to link that table to the RECORDS table to obtain the solicitor names, you can use the PROPOSAL_SOLICITOR.SOLICITORID = RECORDS.ID join. A sample SQL query which illustrates this join is shown below.

select REC.LAST_NAME, REC.FIRST_NAME, PS.AMOUNT
from PROPOSAL_SOLICITOR PS
inner join RECORDS REC on PS.SOLICITORID = REC.ID


Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Our Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.