I have three table in my Database. Email, enrollees and users.
Please view attached picture to get a better understanding. I need to retrieve the 'official_email' data field from the 'enrollees' table. I have the following code but it missing the select statement to where = select ....
I have this case. Into my code the Enrolle id_number is 972432 is not equal to the client.user_id which is 16885. How I can retrieve the 'official email' data from that field into the 'enrollees' table??
<CFQUERY NAME="DisplayEmail" datasource="aar" username="#application.use
WHERE enrollee_id_number = #client.user_id#
Please advise, how I can add another select to the where = select .... .