Select model description
Select vehicle details from the list shown below.
Model descriptions are taken from the VCA database and date from 2001 onwards.
LAND ROVER > Discovery 3 > Petrol / Automatic 6-speed >
Model descriptions are taken from the VCA database and date from 2001 onwards.
LAND ROVER > Discovery 3 > Petrol / Automatic 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 = 'discovery 3' and manu.ManuName = 'land rover' and trans.Description = 'automatic 6-speed' and fuel.FuelName = 'petrol' order by Model, ModDesc, Transmission, Fuel asc