substitute values

[Stelf]

Hiya,

I've seen a tutorial a while back to do this but cannot seem to find one that makes sense to me now.

I have a table which i am storing information in, it also stores the user id of the person who is adding the record, but it is storing the user id as a numeric value which relates to a user in the user_def table.

But what I need to do, is a select on this table where it pulls out data, but alphabetically sorted, so I need to substitute the user id for the persons real name in the query, how can I do this?

Thanks in advance.
Ben

[Wien]

at the end of your query --> ORDER BY Name

[Stelf]

Thanks alot for the reply,

I found a good explaination in a book I had here which I missed before. I fixed my problem by ...

SELECT * FROM spec_dat, user_dat where spec_dat.spec_person = user_dat.user_id and spec_date = '2003-01-22' ORDER BY user_dat.user_name ASC

Then I tightened it up by removing the * and only calling the fields i needed.