Hi All,
Is there a way to make this query more efficient?
Perhaps using group by ?
I am trying to find photos where no photo has been designate as main.
SELECT property.property_id
FROM property
WHERE property.property_id NOT
IN (
SELECT property.property_id
FROM property, property_photo
WHERE property.property_id = property_photo.property_id
AND property_photo_main = '1'
)