Use the convention of table.field in place of where you have the field CONTRACT and take out the SELECT & the FROM PMTRAN. It should look like below. However, it be might easier to just to use the field…