SELECT m.`Model Year`, d.`Division Name` , m.`Model Name` , m.`Model ID`, m.`Model Comment`, m.`Effective Date`, s.`Style ID`, s.`Style Name`, s.`True Base Price`, s.`Invoice`, s.`MSRP`, s.`Destination`, s.`Passenger Capacity`, s.`Passenger Doors`, s.`Manual Trans`, s.`Auto Trans`, s.`CFDriveTrain`, s.`CFBodyType`, ts7.`Text` AS `EPA Classification`, ts256.`Text` AS `Front Head Room`

FROM Divisions d, Styles s, Models m, TechSpecs as ts7, TechSpecs as ts256

WHERE m.`Division ID` = d.`Division ID`
AND m.`Model ID` = s.`Model ID`
AND ts7.`Title ID` = 7
AND ts256.`Title ID` = 256
AND s.`Sequence` = 0