I have a table which displays my records. In column user (in my database) i have a number (user id) but when i display my results it displays names of those users (in my repeat region). (using INNER JOIN) So now i want to apply sorting on each of my table columns and it does not sort users by name, it sorts them by this user id stored in the database. How can i sort those records by user names, not ids?
Thanks in advance