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`
FROM Styles s, Models m

  JOIN TechSpecs.`Text` ON (TechSpecs.`Style ID` = s.`Style ID` AND TechSpecs.`Title ID` = 7)
  JOIN TechSpecs.`Text` ON (TechSpecs.`Style ID` = s.`Style ID` AND TechSpecs.`Title ID` = 256)
  /** ==> #1066 - Not unique table/alias: 'Text' */

WHERE m.`Model ID` = s.`Model ID`
AND m.`Division ID` = d.`Division ID`
AND s.`Sequence` =0