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 ;-) |