Hello
I use a custom field of type SQL. There I use this statement:
Code:
SELECT name_kind_1 AS value, name_kind_1 AS text FROM #__jsn_users WHERE id = [USER_ID]
This works fine. Now I need to get the data from column name_kind_2 as well. So I try:
Code:
SELECT name_kind_1, name_kind_2 AS value, name_kind_1, name_kind_2 AS text FROM #__jsn_users WHERE id = [USER_ID]
But this gives me value of name_kind_2 only. How can I get all data?
Thank you very much.
Patrick
