Select model description
Select vehicle details from the list shown below.
Model descriptions are taken from the VCA database and date from 2001 onwards.
HONDA > Cr-v > Petrol / Manual 5-speed >
Model descriptions are taken from the VCA database and date from 2001 onwards.
HONDA > Cr-v > Petrol / Manual 5-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 = 'cr-v' and manu.ManuName = 'honda' and trans.Description = 'manual 5-speed' and fuel.FuelName = 'petrol' order by Model, ModDesc, Transmission, Fuel asc