Results 1 to 2 of 2
Feb 20, 2013, 12:59 #1
- Join Date
- Sep 2005
- Puerto de Mazarron, Murcia, Spain
- 0 Post(s)
- 0 Thread(s)
Is a sub query necessary for this ?
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.
WHERE property.property_id NOT
FROM property, property_photo
WHERE property.property_id = property_photo.property_id
AND property_photo_main = '1'