Jump to content


Photo

Got id, not name


  • Please log in to reply
1 reply to this topic

#1 Thierry

Thierry
  • Members
  • PipPipPip
  • Advanced Member
  • 85 posts
  • LocationNetherlands

Posted 28 August 2006 - 08:06 AM

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.
Any ideas?
Have you tried....a reset?

#2 Thierry

Thierry
  • Members
  • PipPipPip
  • Advanced Member
  • 85 posts
  • LocationNetherlands

Posted 28 August 2006 - 08:28 AM

Never mind, seem to have found it again, forgot about the whole table_1.id = table_2.id :P
Have you tried....a reset?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users