View Single Post
Old 06-26-2007, 12:08 AM   #4
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

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