Distinct is not working in sql
<pre><code>Select Distinct _Ad.ad_id,_Ad.Ad_Name,ID.Image_Path,VM.year,VD.Vehicle_Transformation,VD.Vehicle_Fuel_Type,VD.Vehicle_Millege
from _Ad 
inner join _Image_Details ID 
on ID.ad_id = _Ad.ad_id
inner join _Vehicle_Model VM
on VM.vehicle_model_id = _AD.vehicle_model_id
inner join _Vehicle_Details VD
on _ad.ad_id=VD.ad_id
inner join _Vehicle_Make VMA
on VM.vehicle_make_id=VMA.vehicle_make_id
where
VMA.Vehicle_Make='' OR
VM.Vehicle_Model='' OR
VD.Vehicle_Fuel_Type='' OR
VD.Vehicle_Seats='' OR
_Ad.price&gt;'0' OR _Ad.price&lt;'8888888'
</code></pre>

<p>i am using this query but its showing 4 records not 1. I need only single record across 1 ad_id. Kindly help. <a href="https://i.stack.imgur.com/zLgEb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/zLgEb.png" alt="enter image description here"></a></p>