The data type image cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable
<pre><code>SELECT cars.carid,cars.variant,  cars.make, cars.model, cars.condition, cars.amount,
       cars.statuss, img.img, seller.fname, seller.lname
FROM img
  INNER JOIN cars
  ON img.carid = cars.carid
  inner join seller
  on seller.sid= cars.sid
where cars.status =1
union
SELECT cars.carid,cars.variant,  cars.make, cars.model, cars.condition, cars.amount,
       cars.statuss, img.img, dealer.fname, dealer.lname
FROM img
  INNER JOIN cars
  ON img.carid = cars.carid
  inner join  dealer
  on dealer.did=cars.did
where cars.status =1
</code></pre>

<p>Query not working. I want to make both the query work at the same time.</p>