| |
|
|
| |
SENWES Used Tractors
SELECT UsedTractors_UsedXpress.YearManufacture, UsedTractors_UsedXpress.Manufacturer, UsedTractors_UsedXpress.Category, UsedTractors_UsedXpress.Model, UsedTractors_UsedXpress.SerialNumber, UsedTractors_UsedXpress.StockNumber, UsedTractors_UsedXpress.PriceAdvertised, UsedTractors_UsedXpress.EngineHours, UsedTractors_UsedXpress.DateCreated, UsedTractors_UsedXpress.Keycode1, UsedTractors_UsedXpress.Keycode2, UsedTractors_UsedXpress.Keycode3, UsedTractors_UsedXpress.Keycode4, UsedTractors_UsedXpress.DaysInUsedXpress, UsedTractors_UsedXpress.DateLastUpdate, UsedTractors_ExtraData.TyreTreadRemaining_Front, UsedTractors_ExtraData.TyreTreadRemaining_Rear, UsedTractors_ExtraData.Notes_Afr, UsedTractors_ExtraData.Notes_Eng, UsedTractors_ExtraData.DateDataImported, UsedTractors_ExtraData.IsSold FROM UsedTractors_UsedXpress LEFT OUTER JOIN UsedTractors_ExtraData ON UsedTractors_UsedXpress.StockNumber = UsedTractors_ExtraData.StockNumber | |
