Hello this is my first topic
I am studying Cs and i got a problem with a select queery.
I have been asked to find m.model,v.vehid,v.km,v.year at the vehicles that have got AirCondition but Not Nitro
i made up with this queery :
select distinct m.model,v.vehid,v.km,v.year from vehicle v inner join models m on m.modid=v.modid inner join veh_extras ve on ve.vehid=v.vehid inner join extras e on ve.extraid=e.extraid and e.descr='AC' inner join veh_extras ve2 on v.vehid=ve2.vehid inner join extras e2 on ve2.extraid=e2.extraid and e2.descr<>'NITRO'
but its Wrong cause it returns the car that has got AC AND Nitro
any help ?