Select model description
Select vehicle details from the list shown below.
Model descriptions are taken from the VCA database and date from 2001 onwards.
LEXUS > Is > Diesel / Manual 6-speed >
Model descriptions are taken from the VCA database and date from 2001 onwards.
LEXUS > Is > Diesel / Manual 6-speed >
Can't get the models using sql: Select vehicle.VehicleID, vehicle.Model, vehicle.ModDesc, trans.Description as Transmission, manu.ManuName, fuel.FuelName as Fuel from tblVehicles vehicle inner join tblManufacturers manu on manu.ManuID = vehicle.ManuID inner join tlkpTransmission trans on trans.TranID = vehicle.TranID inner join tlkpFuelTypes fuel on fuel.FuelID = vehicle.FuelID where vehicle.Model = 'is' and manu.ManuName = 'lexus' and trans.Description = 'manual 6-speed' and fuel.FuelName = 'diesel' order by Model, ModDesc, Transmission, Fuel asc