Dear Sirs,
How do I concatenate two fields from the #__index_users table to show in the dropdown?
I currently have in the 'fields to retrieve' field Data16.id Data16.username, and in the dropdown it appears
Data16.username
My 'users' table:

My 'fields to retrieve' field

My returned sql

My front end dropdown

The desired front end drop down

Thank you in advance
Mauro
How do I concatenate two fields from the #__index_users table to show in the dropdown?
I currently have in the 'fields to retrieve' field Data16.id Data16.username, and in the dropdown it appears
Data16.username
My 'users' table:

My 'fields to retrieve' field

My returned sql

My front end dropdown

The desired front end drop down

Thank you in advance
Mauro