SHOW:
|
|
- or go back to the newest paste.
| 1 | - | 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` |
| 1 | + | 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` |
| 2 | - | FROM Styles s, Models m |
| 2 | + | |
| 3 | FROM Divisions d, Styles s, Models m, TechSpecs as ts7, TechSpecs as ts256 | |
| 4 | - | JOIN TechSpecs.`Text` ON (TechSpecs.`Style ID` = s.`Style ID` AND TechSpecs.`Title ID` = 7) |
| 4 | + | |
| 5 | - | JOIN TechSpecs.`Text` ON (TechSpecs.`Style ID` = s.`Style ID` AND TechSpecs.`Title ID` = 256) |
| 5 | + | WHERE m.`Division ID` = d.`Division ID` |
| 6 | - | /** ==> #1066 - Not unique table/alias: 'Text' */ |
| 6 | + | AND m.`Model ID` = s.`Model ID` |
| 7 | AND ts7.`Title ID` = 7 | |
| 8 | - | WHERE m.`Model ID` = s.`Model ID` |
| 8 | + | AND ts256.`Title ID` = 256 |
| 9 | - | AND m.`Division ID` = d.`Division ID` |
| 9 | + | AND s.`Sequence` = 0 |
