I have a online form and I'm displaying the email field from the email table. This field is not valid anymore. So here is the current script. Please see attached images.
<CFQUERY NAME="DisplayEmail" datasource="aar" username="#application.use
WHERE email.user_id = #client.user_id#
<input type="hidden" name="email" value="#DisplayEmail.email
Now I want do a change and I would like to display the 'official_email' from the ENR table.
I've tried and it didn't work.
FYI, the enrollee_id_number is primary key into the ENR table which is identical to the foreign key id_number in users table.
How can I do it.. .
FROM enr, users
where enr.enrollee_id_number = select .....