Multi table ordering

[Kudose]

Hello all. I am curious to know how to order informaiton that spans multiple tables.

In example, I have the the two following tables:

stock_autos

uid | year | make | model

0 2000 0 escalade
2 2000 1 ram
1 2005 1 ram

manufacturers

mid | make

0 Chevy
1 Dodge

How can I order them by YEAR MAKE MODEL in that order?

I can't seem to come up with any valid SQL.

This code errors stating "unable to jump to row 0"

$row = $db->fetch("SELECT a.*, m.* FROM stock_autos AS a, manufacturers AS m WHERE a.uid='".$l['uid']."' ORDER BY a.year, m.make, a.model ASC");

THANKS!

[devinemke]

SELECT stock_autos.*, manufacturers.* FROM stock_autos, manufacturers WHERE stock_autos.make = manufacturers.mid ORDER BY stock_autos.year, manufacturers.make, stock_autos.model ASC