Can't execute query

select 
				u.unit as unit,
				m.sqft as sqft,
				m.baths as baths,
				m.bedrooms as bedrooms,
				u.rent as rent,
				u.status as status,
				m.views as views,
				u.class as class
			from paulbrown_models as m,
				paulbrown_units as u
			where  order by u.status, u.unit ASC

MySQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by u.status, u.unit ASC' at line 12

This script cannot continue, terminating.





The Paul Brown Loft Apartments logo
The Paul Brown Loft Apartments


on post office square
HOW TO LIVE



Building History
Post Office Square
A Day in the Life
Building Amenities
Loft Amenities
Floorplans
Getting Here
Leasing Information
Contact Us
Resident Resources