Select transmission/fuel type
Select vehicle details from the list shown below.
Model descriptions are taken from the VCA database and date from 2001 onwards.
> S Type >
Model descriptions are taken from the VCA database and date from 2001 onwards.
> S Type >
Can't get the models using sql: Select distinct vehicle.Model, manu.ManuName, trans.Description as Transmission, 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 = 's type' and manu.ManuName = 'jaguar' order by Fuel, Transmission asc