Order by column from other table

Hi,

I'm a beginner in mysql and SQL area.

The problem is that I've got two tables. In the first table some column is
an ID (int value) in the scond table this ID is mapped on string value.

Is there a way to create query that gets data form the first table and
orders it according to ID column, but with string values instead of int
values. Proper strings are taken of course from the second table from rows
that corresponds to integer ID.?

Thanks for any help in advance.

--
Best regards,

Pawel Ratajczak

PS. User form email is written in reverse order ;-)

The wise Pawel Ratajczak enlightened me with:
> Hi,
>
> I'm a beginner in mysql and SQL area.
>
> The problem is that I've got two tables. In the first table some column is
> an ID (int value) in the scond table this ID is mapped on string value.
>
> Is there a way to create query that gets data form the first table and
> orders it according to ID column, but with string values instead of int
> values. Proper strings are taken of course from the second table from rows
> that corresponds to integer ID.?

something like
select * from table1 join table2 using(id) order by table2.stringfield ?

Mark
--
Terantula - Industrial Strength Open Source - http://www.terantula.com/
Projects and administration - +31 6 5140 5160

Mark Huizer <xaa+news_alt.comp.databases.mysql@dohd.org> wrote in
news:slrnf2f21r.2h42.xaa@eeyore.local.dohd.org:

> something like
> select * from table1 join table2 using(id) order by table2.stringfield ?
>

I've checked this in MySQL Query Browser and the result was an arror with
message:
Unknown column 'category_id' in 'from clause'
Error code: 1054

category_id is the name of the column in table1 with int values I wanted to
replace with strings and order by them.

Full query looked like this:
select * from expenses join category using(category_id) order by
category.name;

Any idea what is wrong?

Thanks for any help in advance.

--
Best regards,

Pawel Ratajczak

PS. User form email is written in reverse order ;-)

Pawel Ratajczak <10swen@pratajczak.pl> wrote in
news:Xns9917B3E7847DC10swenwodzusprvpl@127.0.0.1:

> Any idea what is wrong?
>

I've tried with success below query:

SELECT table1.any_field table2.name FROM table1 LEFT JOIN table2 ON
table1.name_id = table2.id ORDER BY table2.name

Thanks for pointing on JOIN function.

--
Best regards,

Pawel Ratajczak

PS. User form email is written in reverse order ;-)