select distid, distiddesc, recordno PersonID, tperson.emailaddress
from wbdconf, outer tperson
where wbdconf.recordno = tperson.personid