Hi,

I have a table that currently displays First Name, Last Name, Role, Email and Phone Number. There are multiple roles including Teacher, Student, Facilitator, etc. What I need is not to display the phone number value of the student in the table if Role is Student, but the table should display the phone numbers of other roles. Is it possible to do? Below is my current query. Thanks, Eric.


SELECT
jos_comprofiler.firstname, jos_comprofiler.lastname, jos_comprofiler.cb_role, jos_users.email, jos_comprofiler.cb_phonenumber FROM `jos_comprofiler`, `jos_users` WHERE jos_users.id = jos_comprofiler.id AND jos_users.usertype = 'Registered'

Hello,

Try to use the next SQL query:



Regards,
ARI Soft

Got it to work. Thanks a bunch.