View Single Post
Old 06-26-2007, 12:08 AM   #1
Pawel Ratajczak
 
Pawel Ratajczak's Avatar
 
Posts: n/a
My Photos: ()

Banked:
MK Cash: $

I am Worth:
MK Cash: $
Donate

Recent Blog: None

Default 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 ;-)
  Reply With Quote
Advertisements