I got a table with a list of names (and their ids) and another table which has a field that contains some of those IDs.
When I want to ORDER BY the IDs in table 2, it (naturally) orders by number. (1,2,3...).
What I want, is it to order by the names from table 1 instead althought only the IDs are in table 2.
It was something in a query with AS but I cant seem to find it again.
Got id, not name
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users